TSQL Tuesday #85 Invite – Backup and Recovery


December 6, 2016 by Kenneth Fisher

T-SQL TuesdayCome on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought we might talk about security.

No. Wait. Sorry, that was last time. This time I want to hear about backup and recovery.

Backups are one of the most common things DBAs discuss, and they are at once one of the simplest and most complicated parts of our whole job. So let’s hear it for backup and recovery!

Need some suggestions for your post? How about:

  • Backups to Azure storage
  • Backing up an Azure SQL DB
  • Filegroup backups and/or piecemeal restores
  • Page restores
  • How do you back up an SSAS cube?
  • The importance of log backups
  • Backup internals
  • Recovery strategies
  • Any other backup related subjects you can think of (BI, SSRS, Sharepoint, certificates & keys, etc)

And you know what? I’d love it if someone (or a few someones) would do a post on simple, basic backups and/or recovery.

At beginning of the year Tim Ford (b/t) created the Entry Level Content Challenge. Basically saying that entry level information is just as important as advanced content, and I agree 100%. Personally I think this would be a great subject for some #EntryLevel content. It’s certainly important stuff.

What is T-SQL Tuesday

T-SQL Tuesday is a blog party started by Adam Machanic (b/t) just over five years ago. The first Tuesday of each month a blogger hosts the party and suggests a topic. Then anyone who is interested blogs on that topic. It can be a lot of fun and quite a challenge to blog on a topic you didn’t pick. Not to mention the time limit. I didn’t mention the time limit? Oh, well, you have one week to write your blog and then it has to be posted on the second Tuesday of the month.

How to join the party
  • Your post must be published on Tuesday December 13, 2016. Don’t be late!
  • Your post must contain the T-SQL Tuesday logo at the top (see above) and the image must link back to this blog post. Otherwise, how will we know it’s a T-SQL Tuesday post?
  • Trackbacks should work, but if not please put a link to your post in the comments section so everyone can see your contribution!
How do I host?

If you want to host just contact Adam and ask for a spot. I believe there is a requirement that you have to have participated in T-SQL Tuesday at least a few times, but hey that’s only reasonable right?

39 thoughts on “TSQL Tuesday #85 Invite – Backup and Recovery

  1. Marek Maśko says:

    Hi Kenneth,

    T-SQL Tuesday logo is missing. Just in case you missed it.

    Best regards,

  2. dallasbikr says:

    ok if I do a video and embed that? Been wanting to test some software a friend recommended 🙂

    • Shouldn’t be a problem as long as it follows the rules. The TSQL2sday image, a link back to this post and a comment here. And of course it has to be posted next Tuesday 🙂

  3. […] a common question “Do you have a backup?” But it’s the wrong question. Very relevant for this month’s T-SQL Tuesday, hosted by Ken Fisher (@sqlstudent144), on the topic of […]

  4. ck says:

    Hey there, found trackbacks dont work in my blog software 🙂
    I wrote a simple post about new snapshot management tools after finding the restore command I had in mind was resigned to the dumpster of history.


  5. […] is time for T-SQL Tuesday #85 and this month the party is being hosted by Kenneth Fisher from SQL Studies.This month’s […]

  6. […] month’s topic is backup and recovery. Backups are one of the most common things DBAs discuss, and they are at once one of the simplest […]

  7. […] month’s T-SQL Tuesday’s topic is about backup and restores. Thanks to Kenneth Fisher (b|t) for hosting this […]

  8. debthedba says:

    Here’s my contribution – thinking about restores: https://debthedba.wordpress.com/2016/12/13/t-sql-tuesday-85-restoring-the-backups/

    Thanks for hosting!

  9. […] You can see the whole post on his blog. […]

  10. […] T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will be plenty of views on backups, I wanted to […]

  11. SQLSoldier says:

    T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups http://sqlsoldier.net/wp/sqlserver/tsqltuesday85partdeuxbackupmythrestoringdifferentialbackups

  12. thomasrushton says:

    Hi Kenneth,

    Here’s a quickie about backup compression. Should fit into the #EntryLevel category nicely. 🙂


  13. Hi Kenneth,
    My entry for this month – http://stuart-moore.com/easier-sql-server-restores-dbatools/

    Another one on the importance of actually trying to restore your backups, but this time introducing some new features in DBATools that make it much easier.


  14. Hi Kenneth,

    Here is my contribution to this months topic: “Backup and restore for multi-tenant databases (in the cloud)”


    Best wishes,
    Kennie Nybo Pontoppidan

  15. […] months T-SQL Tuesday is hosted by Kenneth Fisher(b|l|t) and the invitation is found following this […]

  16. T-SQL Tuesday #85: dbatools to the backup/restore rescue – highlights the current commands we have for backup and restore, such as Get-DbaBackupHistory and Get-DbaRestoreHistory – and even includes a video demo of one of my favorite commands, Test-DbaLastBackup.


  17. […] invites us to write about Backup and Recovery. I felt that I covered a lot of ground in my performance tuning backup and restore operations post, […]

  18. amtwo says:

    Thanks for hosting, Kenneth!

    Backup + Recovery + ☁️:

  19. […] It’s T-SQL Tuesday,  the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery […]

  20. […] the last T-SQL Tuesday of the year, this month is being hosted by Kenneth Fisher (b|t) and is about backup and […]

  21. dhammer3407 says:

    STOP! Restore Time! Here is my post about STOPAT, STOPATMARK, and STOPBEFOREMARK. http://www.sqlhammer.com/t-sql-tuesday-85-stop-restore-time/

  22. Hi Kenneth

    Sorry for the late entry, I haven’t been able to get trackback to work, so now I am posting this manually.
    The blog post came out Tuesday, as supposed. Only this entry is late.
    The blog post is at http://t-sql.dk/?p=1900 and is called “T-SQL Tuesday #85- SSAS(MD) Backup Galore”

  23. […] TSQL Tuesday of 2016. My subject was backup and recovery and I was pleased to see this line of my invitation quoted several […]

  24. […] #85 – Backup and Recovery […]

  25. […] Invitation and roundup from Ken Fisher. […]

Leave a Reply to Chrissy LeMaire Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: