Thursday, November 5, 2009
Can you give me some DBCC command options?
(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment