November 21, 2007 at 2:32 am
Guys,
What is the best option among below
1- Backup database and then re-indexing / integrity checks
2- Re-indexing / integrity checks then backup databases
Thanks and Regards
Javed Iqbal
November 21, 2007 at 2:42 am
2- Re-indexing / integrity checks then backup databases
No point in taking backup of currupt database.
November 21, 2007 at 2:44 am
Hi,
If you see in the maintenance plan, Microsoft does things in the following order
1- Reindex
2- Check DB integrity
3- Backup DB
Regards,
Ahmed
November 21, 2007 at 2:47 am
Thanks,
I was thinking the same.
I was asked to justify hence thought to get SQL GURU's comments 🙂
Regards
Javed Iqbal
November 22, 2007 at 12:57 am
Is it better to run your backups daily and your tuning (index's,etc) weekly, or should tuning be done before every backup?
November 22, 2007 at 5:17 am
Tuning can be done on the weekly basis. and backupd daily.
But if you require to tune and backup database on daily basis. then tuning has to be done prior to backups.
Regards
Javed Iqbal
November 22, 2007 at 5:20 am
Hi,
You are rigth.
If we talk about strategies it depends on a lot of considerations.
In my case I do the following
- Backup
- Daily Full backup at 12Am.
- Differential Backup each 6 hours
- Trnsaction log backup each 1 hour
- Checking the database and reindexing each 2 weeks.
Regards,
Ahmed
November 24, 2007 at 8:58 pm
Scott Keatinge (11/22/2007)
Is it better to run your backups daily and your tuning (index's,etc) weekly, or should tuning be done before every backup?
It depends on how much the data changes. If the data changes very, very little (or if only a small part of the data changes), then re-indexing isn't necessary every day. Most of the databases I manage I re-index weekly because daily re-indexing simply isn't necessary to maintain decent performance.
K. Brian Kelley
@kbriankelley
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply