Category Archives: Backups

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

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

    4

    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

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

  4. RESTORE VERIFYONLY what does WITH LOADHISTORY do?

    2

    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

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

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

    1

    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

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

  8. SQL Homework – July 2017

    11

    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

  9. Backup to NUL

    6

    June 5, 2017 by Kenneth Fisher

    Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In …
    Continue reading

  10. Compressed backup errors and TF 3042

    6

    March 16, 2017 by Kenneth Fisher

    Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
    Continue reading

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

Join 2,469 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013