Dba 101

Database Skills Checklist

DBA Guides


Configuration




Shrinkfile

Security -

DBCC
  • DBCC CHECKDB ('DatabaseName') WITH NO_INFOMSGS
  • DBCC CHECKDB ('DatabaseName') WITH PHYSICAL_ONLY
  • DBCC UPDATEUSAGE(‘DatabaseName’)

Managing MSDB