Tag Archives: backups

  1. When was this database restored?


    July 27, 2016 by Kenneth Fisher

    I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. …
    Continue reading

  2. Want to be able to read your database between restores?

    Leave a comment

    July 20, 2016 by Kenneth Fisher

    When restoring a database there are times when it would nice to restore a bit, check what’s been restored so …
    Continue reading

  3. Database snapshots


    June 22, 2016 by Kenneth Fisher

    This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
    Continue reading

  4. Help! My backup file has doubled in size.


    June 16, 2016 by Kenneth Fisher

    Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
    Continue reading

  5. RAID your backups


    May 16, 2016 by Kenneth Fisher

    Let’s start with a very brief definition of some RAID levels. RAID 0 : Stripe your data across multiple disks. …
    Continue reading

  6. Changing to simple recovery to clear the log.


    February 10, 2016 by Kenneth Fisher

    Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries …
    Continue reading

  7. Copying a TDE database from one instance to another


    June 22, 2015 by Kenneth Fisher

    I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
    Continue reading

  8. TSQL Tuesday #66: Monitoring


    May 12, 2015 by Kenneth Fisher

    If a user is going to call me about problem, I’d much rather know about it ahead of time. In …
    Continue reading

  9. Backup before you restore


    April 22, 2015 by Kenneth Fisher

    You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back …
    Continue reading

  10. Make sure you back up the Service Master Key


    April 8, 2015 by Kenneth Fisher

    I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,244 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013