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 |
|
maryxu
Starting Member
36 Posts |
 Posted - 2008-04-01 : 09:51:20
|
| On maintenance plan, there is a check box on integrity tab page, is it a good practise to do that first? if there is error found, will the backup stop? thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-01 : 22:32:30
|
| You can do it before or after backup, will not affect backup in either way. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-02 : 14:26:46
|
| I run it first, as a separate job, because if there is an issue, the backup won't run in the maintenance plan. However, if the backup does run and there were integrity errors, it would be a corrupt backup anyway, right? I do it first with the assumption everthing is fine. I also run all other maintenance jobs prior to backups because if something went wrong after the backup (user deletes important data, disks fail), the data and indexes and whatever are all optimized and I have less downtime, simply restores as opposed to restores and other maintenance jobs before turning it back over to the users. As you see, 2 different opinions. You need to determine what is appropriate for your business. (but ALWAYS do backups).Terry |
|
|
|
|
|
|
|
|
do integrity check before backup