SQL Server Backup
Best Practices and Articles
Here’s what we’ve put together over the years to protect your data.
- SQL Server Backup Best Practices – my own best practices for backing up databases from the 10+ years I’ve been doing it.
- Back Up To The Network, Not Local Disk – I explain why you shouldn’t write your SQL Server backups to the same disks your data lives on.
- Carbonite Failures – I talked about the problems with Carbonite, and what DBAs can learn from them. I also followed up on the Carbonite issues after David Friend (their CEO) commented on the blog.
- Journalspace Failure – another dot-com bites the dust because they didn’t have good database backups.
- Ma.gnolia Backup Failures – online bookmark sharing service couldn’t restore from backups, and went under.
- Browse All Posts Tagged “Backup”
SQL Server Backup and Restore Training Class
There is no more critical task for a DBA than to back up the business data – except perhaps restoring it to ensure validity. A disaster – in many forms – can strike at any time. SQL Server offers many backup and restore options, to help you meet business requirements.
In Jes Schultz Borland’s 2-hour video class, you’ll learn about:
- Simple, Full, and Bulk logged recovery models
- Full, differential, and log backups
- Restore options
- Best practices
It always helps when you see something in action, so she’ll demonstrate
- Full backups
- Differential backups
- Log backups