Tag Archives: backups

  1. TSQL Tuesday #66: Monitoring

    1

    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

  2. Backup before you restore

    3

    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

  3. Make sure you back up the Service Master Key

    3

    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

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

    5

    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

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

    1

    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

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

    1

    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

  7. Database default locations

    4

    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

  8. Generating a restore script

    3

    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

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

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

    3

    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

Follow

Get every new post delivered to your Inbox.

Join 768 other followers