December 5, 2005 at 10:50 pm
Hi.
I have a production server SQ2k where I do complete backup daily at once in the nite (scheduled job).
Backup is doing every 24hrs time. If my database get crashed or damaged during the day or in between the 24 hrs, I believe that I will loose all information that entered during the day. Only option is to restore DB from latest Backup.
Is there any way that I can run a contnous log file backup ?. What I'm trying here is basically to run full backup daily at 10:00pm. then put new tape and start continous backup of log till next day 10:00pm. This is something silimar to informix (ontape -c)
Aprpeciate all your comments.
Rgfds-
December 6, 2005 at 8:14 am
You can not do a continuous log backup however you can backup your transaction log at any interval (10 minutes). This will allow you to restore up to the last to minutes. Also, when some failures occur it is still possible to backup the remaining transaction log which will bring you to current.
If you need to guarantee zero transactional loss you should look at another solutions such as clustering, replication, hardware mirroring, or a combination of the three.
December 6, 2005 at 9:24 am
Thanks Jason.
>> however you can backup your transaction log at any interval (10 minutes).
HOW CAN I SETUP ABOVE through SQL JOB ? Please advise..
Rgds
December 6, 2005 at 11:18 am
I would use the native SQL Maintenance plans for this. In enterprise manager in the management section you can create a maintenance plan to backup the transaction log at any interval that you specify. You can also have this delete any backup files that are older than X number of days which helps to more efficiently manage your disk.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply