dbcc commands after restore | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

dbcc commands after restore

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
If restore is the same SQL, I suggest to run DBCC CHECKDB.
If in other SQL, then same DBCC plus Update Statistics.
Luis Martin
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.