SQL Server Performance Forum – Threads Archive
dbcc commands after restoreHi,
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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
try this commands also,
Regards Hemantgiri S. Goswami
"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.