Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DBCC check every backup?
- Thread starter jfdugan
- Start date
- Thread starter
- #3
mrdenny
Programmer
- May 27, 2002
- 11,595
ok, so it's running DBCC CHECKDB ('database_name') WITH PHYSICAL_ONLY
If you check DBCC CHECKDB is Books online it should provide you with the information your need.
There is no problem with using the database while CheckDB is being run, however it will slow the system down. There is no need for this to be run daily. For my large databases I run checkdb weekly, on the weekends so as to not effect users.
Denny
If you check DBCC CHECKDB is Books online it should provide you with the information your need.
There is no problem with using the database while CheckDB is being run, however it will slow the system down. There is no need for this to be run daily. For my large databases I run checkdb weekly, on the weekends so as to not effect users.
Denny
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question