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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2006-06-05 : 06:44:46
|
| HiI want to have a full backup once per month and the a twice daily differential back up.So that I can go back to any half day point in the last 4 weeksBut do I get my full monthly backup to overwrite the existing full one in order to start again. and then does this mean that if i want to restore I can't go back 1 week because I have just done a full back up. (hope that makes sense)e.g. I do a full monthly on the 30th which overwrites the existing media (incl all the diffs) then decide I want to go back to how the database was on the 22nd of the month...I can't because I've only got a full back up from the 30th) Cheers ICW |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-05 : 06:52:59
|
| Correct, you should not overwrite the Full Backup because you won't be able to restore to an earlier DIFF.However, you do need to get the backups off the disk and on to Tape, or somesuch, so if you are happy to restore from them in the circumstance you describe then overwriting would be fine - provided you can rely on your tape backup routines!The alternative is to "rename" the old backup file first:DELETE MyOldBackupFileRENAME MyCurrentBackupFile MyOldBackupFileMake new MyCurrentBackupFileKristen |
 |
|
|
|
|
|
backup plan