Showing posts with label Can you give me some DBCC command options. Show all posts
Showing posts with label Can you give me some DBCC command options. Show all posts
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:
Posts (Atom)