Answers

Question and Answer:

  Home  SQL Server DB Administrator

⟩ As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

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.

 134 views

More Questions for you: