Tag Archives: Backup/Recovery

When Did That Restore Finish?

Posted on July 28, 2011 by way0utwest

I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the default trace, I was thinking msdb.dbo.restorehistory and decided to check. First I hit Books Online. It notes that the restore_date … Continue reading →

Posted in Blog | Tagged , , | Comments Off on When Did That Restore Finish?

SQL Server Backup – Inadvertent Striping

Posted on July 18, 2011 by way0utwest

When I started working with SQL Server I got bit in the rear one day while I was testing backups. I was in the process of making a quick backup before I deployed some changes. I think this was in … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Server Backup – Inadvertent Striping

Striping Backups in SQL Backup Pro

Posted on July 11, 2011 by way0utwest

There are times you really do want to stripe backups across multiple files. If you have a short backup window, or a large data set, if you can write the backup to multiple files at the same time, you can … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Striping Backups in SQL Backup Pro

Recovering a Database

Posted on July 6, 2011 by way0utwest

So you’re restored a database, restored a few logs, all with NORECOVERY as expected and realize there are no more logs. You see this in Management Studio and wonder what do to: I’ve run a bunch of code, restoring lots … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Recovering a Database