Category Archives: Backups

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

  2. SQL Homework – July 2017

    9

    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

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

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

  5. What’s in my backup file?

    Leave a comment

    February 22, 2017 by Kenneth Fisher

    Restoring a backup file is pretty easy right? Ok, but what if more than one database backup is stored in …
    Continue reading

  6. What is COPY_ONLY?

    2

    January 16, 2017 by Kenneth Fisher

    You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up …
    Continue reading

  7. A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

    Leave a comment

    December 26, 2016 by Kenneth Fisher

    I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery …
    Continue reading

  8. DBA Myths: You can only restore one differential backup

    1

    December 13, 2016 by Kenneth Fisher

    Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.   The …
    Continue reading

  9. TSQL Tuesday #85 Invite – Backup and Recovery

    39

    December 6, 2016 by Kenneth Fisher

    Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
    Continue reading

  10. If backups are taken in silence can a recovery still take place?

    3

    October 11, 2016 by Kenneth Fisher

    My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a …
    Continue reading

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

Join 2,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013