DaveWentzel.com All Things Data
Backup And Recovery Page
Backup using batch files and NT scheduler (useful for SQL Express)
Don't Backup Your Indexes...it can save you time if you don't need them.
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.
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.