Tag Archives: Backup/Recovery

SQL Backup 7

Posted on April 24, 2012 by way0utwest

What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s SQL Backup Pro, have been able to handle the things most DBAs care about for some time: compression and encryption. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Backup 7

Backup and Restore

Posted on March 30, 2012 by way0utwest

Today’s editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. I think that it’s important to practice restoring and rebuilding your systems. You never know when you’ll encounter problems and … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Backup and Restore

Where’s My Backup? SQL Server Backup Issues

Posted on February 21, 2012 by way0utwest

You can cause yourself problems if you don’t know where your backups are stored, and how they are being made. It also helps to understand the defaults of how your backups are created in files. Here’s a short story to … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Where’s My Backup? SQL Server Backup Issues

Filestream and Backups

Posted on November 7, 2011 by way0utwest

What happens when you backup a filestream enabled database in SQL Server 2008? According to BOL, your data is backed up as part of the normal backup process. Does it work? Let’s do a little test. I made a simple … Continue reading →

Posted in Blog | Tagged , | Comments Off on Filestream and Backups