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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2012-02-14 : 17:32:26
|
| Can I run DBCC checkdb while the db is online and people are accessing the system my database is huge do I need a lot of disk space to do thatWill this help me to find if an index is corrupted.Thankssarah |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-02-14 : 17:41:00
|
| How big is your database?Yes you can definitely do this online, however it will use a lot of IO and can/will cause performance issues. The best way to do this is to NOT run this on production, but rather backup/restore to a test system and run CheckDb on the test system instead. We do this with our larger databases and only run CheckDb on production for the system databases and smallish ones.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
can I run DBCC CheckDB while db is online