Category Archives: Backups

  1. SQL Homework – July 2021 – Log shipping

    Leave a comment

    July 1, 2021 by Kenneth Fisher

    Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy …
    Continue reading

  2. SQL Homework – April 2020 – Continuity planning.


    April 1, 2020 by Kenneth Fisher

    Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world …
    Continue reading

  3. Help! My restore has finished but the database still has a status of recovering.

    Leave a comment

    January 8, 2020 by Kenneth Fisher

    I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, …
    Continue reading

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

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

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

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

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

  10. SQL Homework – March 2018 – Recovery Objectives


    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

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

Join 3,548 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013