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 |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2004-12-10 : 03:09:09
|
| Dear All, There is a backup strategy as following: - Full backup at weekend at night - Twice Log backup every day in the morning and afternoon - Reindex and shrink database every sunday Any comment about this backup plan? |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-12-10 : 06:06:32
|
| Seems to be OK.What if TUESDAYS log backup corrupted and you come to know about it only on saturday? The subsequent log backups are useless. Suggesting the following....- Full backup at weekend at night- Twice Log backup every day in the morning and afternoon- DIFFERENTIAL BACKUP EVERY NIGHT.- Reindex and shrink database every sunday------------------------I think, therefore I am |
 |
|
|
|
|
|
Ask for comment on backup strategy