June 1, 2010 at 6:26 am
If I run a full DB Backup (BAK) of my SQL 2000 DB and users are locked out is there any reason to perform a transaction log backup when my goal is to RESTORE the full backup on another server?
I don't want to lose any data and am currently assuming a full backup is a FULL backup.
Thanks
June 1, 2010 at 6:42 am
Full backup will backup committed data....it will be a wise decision to take log backups and restore on other server however the possibility is still that the copy that is on the other server is not completely inline with prod as there will changes that will happen at the time of restore...
You can look in to the option of Log shipping or Replication if the environment permits.
Use any of the options wisely.
~RD
June 1, 2010 at 9:15 am
I don't think you need to run a t-log backup if there are no users in the system, and no other activity such as scheduled jobs or data imports. If there's any doubt, you could detach the database, copy the files (.mdf, .ldf) and attach at the destination.
June 1, 2010 at 1:57 pm
Thanks guys - I will be turning off known services and setting the source DB to "Single_User" before I take the backup. I will make sure there are no connections that could modify the DB. I'm hoping to get away with a simple Backup/Restore of the BAK. As always, I appreciate the input.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply