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 |
|
mehlert
Starting Member
1 Post |
 Posted - 2007-07-13 : 11:56:53
|
| we have MS SQL 2005 Standard and we have setup Maint. Plans with the SQL Server Management Studio front end.i didn't set this up, so if it's completely crazy, i'm just the messenger :)we have two maintenance plans:maintenance plan A (to generalize) runs its full back up, then generates its differential backups and transactional logs.then maintenance plan B runs its full back up and generates differential backups on a second drive without transactional logs.what appears to happen with this is MS SQL will only let us restore from the most recent differential, so if maintenance plan B's differential ran last, it renders maintenance plan A's differentials essentially useless.the reason it was setup this way was that in theory, we wanted A to backup to one drive and B to backup to a drive that gets rotated for offsite backup.if we're breaking diff backups, this isn't optimal. anyone have a better method for creating backups on primary backup drive and a swap out drive?thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-13 : 18:19:56
|
| Run backup on drive a then copy backup files to drive b. |
 |
|
|
|
|
|
problems running two diff backups