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 |
|
Liew2020
Starting Member
26 Posts |
 Posted - 2008-05-31 : 12:48:54
|
| Hi,Appreciated someone able to provide me some clu on how to perfom DBCC CHECKDB. Is it necessary to set the database to "Read only" before execute DBCC CHECKDB?Appreaciated your help.Regards,Jimmy Liew |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-31 : 14:41:04
|
| check Books online. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-06-02 : 03:36:41
|
| If you're just doing the check, there's no special condition the DB has to be in. Be aware that CheckDB, especially on a large database can be an intensive operation.--Gail Shaw |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-02 : 11:42:30
|
| DBCC checks the allocation, and integrity of all objects.If you have big size DB and do not try to run DBCC CHECKDB() on business time, It will take all resorces.ManojMCP, MCTS |
|
|
|
|
|
|
How to perform DBCC CHECKDB