Category Archives: Backups

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

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

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

  4. TSQL Tuesday #85 Invite – Backup and Recovery

    36

    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

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

  6. Copying an on-premise Database to an Azure SQL Database

    3

    August 24, 2016 by Kenneth Fisher

    Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud. …
    Continue reading

  7. When was this database restored?

    3

    July 27, 2016 by Kenneth Fisher

    I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. …
    Continue reading

  8. Want to be able to read your database between restores?

    Leave a comment

    July 20, 2016 by Kenneth Fisher

    When restoring a database there are times when it would nice to restore a bit, check what’s been restored so …
    Continue reading

  9. Database snapshots

    4

    June 22, 2016 by Kenneth Fisher

    This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
    Continue reading

  10. Help! My backup file has doubled in size.

    2

    June 16, 2016 by Kenneth Fisher

    Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
    Continue reading

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

Join 1,598 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013