SQL Server Soldier :: News from the frontlines of the database wars

Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test

For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from database snapshots. Someone asked me recently if I had any recommendations for speeding up their unit testing on replicated databases. He has to run unit tests over and over on…

1 comments, 431 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 25 February 2013

SQL Saturday #198, Vancouver, BC Session Files

This past weekend was SQL Saturday #198 in Vancouver, B.C. It started off with a leisurely drive up to Vancouver on Friday and getting settled in to my hotel room. I was in the first slot of the day, and had a decent turnout despite the early hours. Whenever I…

0 comments, 320 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 19 February 2013

Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies

Welcome to day 28 of my series 31 Days of Disaster Recovery. Today I want to talk about recovering SQL Server if your tempdb drive suddenly dies. SQL Server won’t start if it can’t start up tempdb, so it poses a challenge if you can’t get the drive up and…

4 comments, 1,473 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 February 2013

Day 27 of 31 Days of Disaster Recovery: Restoring Part of a Database

Today is day 27 of my series 31 Days of Disaster Recovery, and I want to talk about restoring a partial database to a server. If you have a very large database with many filegroups, and you need to restore just part of the database, then you can perform a…

0 comments, 390 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 February 2013

SQLSoldier World Tour Kicks Off in 1 Week

The SQLSoldier World Tour kicks off this next Friday when I head up to Vancouver, in British Columbia, Canada. I will be doing 1 session on Saturday called Implementing Contained Databases. If you haven’t worked with this feature yet, I think I have quite a few things to tell you…

0 comments, 368 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 February 2013

Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup

Welcome back for day 26 of my series 31 Days of Disaster Recovery. Today I want to share a tale of a mysterious backup that was running too long, and as the SAN admin reported, nothing had changed in terms of configuration of the SAN or our LUNs. We eventually…

4 comments, 387 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 February 2013

Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores

My series 31 Days of Disaster recovery has been on hiatus due mostly to illness. I’ve been battling a chest cold that became bronchitis. I’m still fighting cough, but even that has improved to the point that I’m now sleeping longer at night than night. It wasn’t so much that…

6 comments, 418 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 February 2013

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Archives: February 2013

Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test

SQL Saturday #198, Vancouver, BC Session Files

Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies

Day 27 of 31 Days of Disaster Recovery: Restoring Part of a Database

SQLSoldier World Tour Kicks Off in 1 Week

Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup

Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores