SQL Server Performance Forum – Threads Archive

dbcc commands after restore

Hi,
What dbcc commands should you run after doing the restore. Also is there anything else you need to do to check the database after you have restored it. Thanks
Anu

If restore is the same SQL, I suggest to run DBCC CHECKDB.
If in other SQL, then same DBCC plus Update Statistics.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hi ,
try this commands also,
dbcc checkalloc
dbcc checkcatelog
dbcc updateusage
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

THere is no requirement to perform DBCC statements when you restore, for optimum performance perform as suggested by Luis. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>