Tag Archives: backups

  1. DBA Myths: Can a differential backup get bigger than the full backup?


    February 14, 2019 by Kenneth Fisher

    The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one …
    Continue reading

  2. What’s a differential backup?


    January 23, 2019 by Kenneth Fisher

    Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently …
    Continue reading

  3. Moving SSISDB is not as easy as it sounds

    Leave a comment

    December 10, 2018 by Kenneth Fisher

    We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016 …
    Continue reading

  4. My backup script (where, how, how big, etc.)


    November 26, 2018 by Kenneth Fisher

    A while back I wrote about how to find where your backups are. And I’ve also written about I use …
    Continue reading

  5. SQL Homework – September 2018 – Backup and Restore continued.

    Leave a comment

    September 3, 2018 by Kenneth Fisher

    In the very first SQL Homework post you were asked to take a backup. In fact it asked you to …
    Continue reading



    July 18, 2018 by Kenneth Fisher

    Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the …
    Continue reading

  7. SQL Homework – March 2018 – Recovery Objectives

    Leave a comment

    March 5, 2018 by Kenneth Fisher

    My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
    Continue reading

  8. Backups of backups or How long is my backup really available?


    February 7, 2018 by Kenneth Fisher

    I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, …
    Continue reading

  9. Schema only backup or schema only DB copy

    Leave a comment

    October 25, 2017 by Kenneth Fisher

    Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded …
    Continue reading

  10. SQL Homework – July 2017


    July 3, 2017 by Kenneth Fisher

    For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a …
    Continue reading

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

Join 3,085 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013