SQL Server Database Administrator Question:
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
Answer:
DBCC CHECKDB,
DBCC CHECKTABLE,
DBCC CHECKCATALOG,
DBCC CHECKALLOC,
DBCC SHOWCONTIG,
DBCC SHRINKDATABASE,
DBCC SHRINKFILE etc.
But there are a whole load of DBCC commands which are very useful for DBAs.
DBCC CHECKTABLE,
DBCC CHECKCATALOG,
DBCC CHECKALLOC,
DBCC SHOWCONTIG,
DBCC SHRINKDATABASE,
DBCC SHRINKFILE etc.
But there are a whole load of DBCC commands which are very useful for DBAs.
| Previous Question | Next Question |
| What is the different types of BACKUPs available in SQL Server? | Explain what is a Schema in SQL Server 2005? Explain how to create a new Schema in a Database? |