Hello, Everyone:
How to check if a database is corrupted, and how to fix the corruption? Thanks.
ZYTDBCC CHECKDB will give you some info on your data, DBCC CHECKCATALOG will report on system-related objects' problems of your db. I'm still using DBCC NEWALLOC from 6.5 world to actually fix any allocation-related issues. The last command reports AND fixes at the same time.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment