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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-18 : 08:36:39
|
| manish writes "is it possible to run checkdb in slots. means i want to run checkdb for 2 hour today and 2 hour nextday on the same database and so on for 50 gb database. as checkdb is taking 12 hours and i want to run this in 6 days incremental as backup does.any help will be appreciated.thanx in advance.... manish" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-18 : 09:17:49
|
| Can you restore the backup on run it on that version? I never like running checkdb on a live system.Otherwise you can run checktable on individual tables.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-01-19 : 01:33:13
|
| You can't split DBCC CHECKDB operation... it is single transaction...As NR mentioned you run DBCC CHECKTABLE ...few table every day...MohammedU |
|
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-19 : 02:43:55
|
| as per BOL, DBCC CHECKDB internally do the following step(a) Runs DBCC CHECKALLOC on the database(b) Runs DBCC CHECKTABLE on every table and view in the database(c) Validates the Service Broker data in the database(d) Runs DBCC CHECKCATALOG on the database(e) Validates the contents of every indexed view in the databasewhat we can do is instead of DBCC CheckDB, run these steps individually at different timeMadhu |
|
|
|
|
|
|
checkdb