is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanksHi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:
> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks