Tag Archives: backups

  1. 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

  2. SQL Judo’s Monthly Challenge – January 2014 – Restore the Master


    January 5, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

  3. Playing with the log – VLF order while growing the log


    December 17, 2014 by Kenneth Fisher

    The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of …
    Continue reading

  4. Playing with the log – Before the first full backup


    October 29, 2014 by Kenneth Fisher

    The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
    Continue reading

  5. Database default locations


    September 29, 2014 by Kenneth Fisher

    One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
    Continue reading

  6. Generating a restore script


    August 18, 2014 by Kenneth Fisher

    In order to speed up our backups on a large database our team decided to stripe the backup files. In …
    Continue reading

  7. Transactions: Creating a single restore point across multiple databases.

    Leave a comment

    February 3, 2014 by Kenneth Fisher

    This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple …
    Continue reading

  8. I’ve refreshed a test database from prod but now the users can’t access it.


    October 9, 2013 by Kenneth Fisher

    This happens to me all the time. I get a request from a developer to overwrite the test copy of …
    Continue reading

  9. Brad Shultz’s blog on reviewing your database


    September 17, 2013 by Kenneth Fisher

    This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
    Continue reading

  10. “My transaction log is too big!”


    August 12, 2013 by Kenneth Fisher

    “My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written, …
    Continue reading


Get every new post delivered to your Inbox.

Join 719 other followers