Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slayer
Starting Member
3 Posts |
 Posted - 2006-03-16 : 08:10:33
|
| I have to perform a backup for disaster recovery purposes before an application upgrade. The upgrade will alter the database and stored procedures. My cuurent backup takes a backup of master and msdb weekly. The user database uses the Full Recovery model and is backed up daily at 21:00 and the logs daily at 13:00. Assuming the databse is modified between the last backup and the upgrade starting at 9:00am what should my backup stratergy be for roll back purposes.1) backup master, msdb and the user Database to a different location than the normal backups. Use these to restore if required2) backup the master, msdb and user databases using the same jobs and therefore overwriting the original evening backups3) do nothing and just restore master and msdb from a backup and replay the logs to a given point in time for thr user database should the upgrade fail Any help or suggestions will be much appreciated. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-16 : 08:29:49
|
| Judge how long your backup takes, then run it so it finishes just before you start the upgrade.. |
 |
|
|
slayer
Starting Member
3 Posts |
Posted - 2006-03-16 : 08:48:54
|
| That would work but I dont want to alter the normal backups as this would expose a larger time frame from the previous day without a backup. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-16 : 09:09:13
|
| So just add an extra schedule to them for a one time run.. |
|
|
|
|
|
|
Database backups