DaveWentzel.com            All Things Data

Backup And Recovery Page

Backup and Zip Routine

 
Don't Backup Your Indexes...it can save you time if you don't need them. 
 
 
Database Mirroring
Some useful tips:
  • if clustering is used at the principal then don't use a witness
  • the mirror can use 4x more IO than the principal...plan accordingly. 

How to Fix a Suspect Database

 
Recovery Issues
Recovery Models:  everything you want to know about recovery models. 
sp_kill_connections_quick:  for 2000...allows you to kill all connections to the db so you can restore it.  Not needed with 2005/2008 since ALTER DATABASE WITH ROLLBACK IMMEDIATE SET SINGLE USER does the same thing. 
 
Transaction Log Issues
DBCC REBUILD_LOG when you lost your log file and your database is suspect. 
 

Add new comment