Dba 101

Guides

• Server Quick check notes 
  
• Database Maintenance Checklist
• Analysing a SQL Database 

• RESTORE - FILELISTONLY / TSQL
• Orphanned Logins

Configuration

• Default Port Numbers

Shrinkfile

Security -

• Login Error Codes

DBCC

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

Managing MSDB

• Delete SQL Agent Job History
• Remove Database Backup History
• Remove files over X days old