TSQL Tuesday #85 Invite – Backup and Recovery
39December 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 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?
SQL Studies 
Hi Kenneth,
T-SQL Tuesday logo is missing. Just in case you missed it.
Best regards,
Marek
Added. *sigh* Lots of problems with this post. Sorry about that.
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 🙂
[…] 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 […]
Thanks for hosting again, Ken! http://sqlblog.com/blogs/rob_farley/archive/2016/12/13/backups-are-you-missing-the-point.aspx
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.
https://constantinekokkinos.com/articles/61/t-sql-tuesday-85-managing-snapshots-in-dbatools
My entry – https://blobeater.blog/2016/12/07/tde-recovery/
[…] is time for T-SQL Tuesday #85 and this month the party is being hosted by Kenneth Fisher from SQL Studies.This month’s […]
T-SQL Tuesday #86 Alternatives To Backup & Restore
http://itsalljustelectrons.blogspot.com/2016/12/TSQL-Tuesday-86-Alternatives-To-Backup-Restore.html
Thanks for hosting, Kenneth!
[…] 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 […]
Well here’s my contribution. https://sqlstudies.com/2016/12/13/dba-myths-you-can-only-restore-one-differential-backup/
http://dallasdbas.com/tsql2sday-backup-basics/
Here’s mine, thanks Kenneth!
https://blogs.sentryone.com/aaronbertrand/backups-worthless/
[…] month’s T-SQL Tuesday’s topic is about backup and restores. Thanks to Kenneth Fisher (b|t) for hosting this […]
Here’s my contribution – thinking about restores: https://debthedba.wordpress.com/2016/12/13/t-sql-tuesday-85-restoring-the-backups/
Thanks for hosting!
[…] You can see the whole post on his blog. […]
T-SQL Tuesday #85: Backup Log With NoRecovery http://sqlsoldier.net/wp/sqlserver/tsqltuesday85backuplogwithnorecovery
Proper Backup Alerting – MinionWare.net http://minionware.net/proper-backup-alerting/
[…] 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 […]
The Most Important Role of a SQL Server DBA http://procuresql.com/blog/2016/12/the-most-important-role-of-a-sql-server-dba/
T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups http://sqlsoldier.net/wp/sqlserver/tsqltuesday85partdeuxbackupmythrestoringdifferentialbackups
Hi Kenneth,
Here’s link to my post about Maintenance Plans.
Hi Kenneth,
Here’s a quickie about backup compression. Should fit into the #EntryLevel category nicely. 🙂
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.
Cheers
Stuart
Hi Kenneth,
Here is my contribution to this months topic: “Backup and restore for multi-tenant databases (in the cloud)”
http://www.pontop.dk/single-post/2016/12/13/T-SQL-Tuesday-85—Backup-and-restore-for-multi-tenant-databases-in-the-cloud
Best wishes,
Kennie Nybo Pontoppidan
[…] months T-SQL Tuesday is hosted by Kenneth Fisher(b|l|t) and the invitation is found following this […]
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.
https://blog.netnerds.net/2016/12/dbatools-to-the-backuprestore-rescue/
[…] 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, […]
Thanks for hosting, Kenneth!
Backup + Recovery + ☁️:
https://www.am2.co/2016/12/tsql-tuesday-85-backup-recovery/
[…] 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 […]
[…] the last T-SQL Tuesday of the year, this month is being hosted by Kenneth Fisher (b|t) and is about backup and […]
STOP! Restore Time! Here is my post about STOPAT, STOPATMARK, and STOPBEFOREMARK. http://www.sqlhammer.com/t-sql-tuesday-85-stop-restore-time/
I posted the list of blog entries here: https://sqlserver.miraheze.org/wiki/TSQL_Tuesday_85
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”
[…] TSQL Tuesday of 2016. My subject was backup and recovery and I was pleased to see this line of my invitation quoted several […]
[…] #85 – Backup and Recovery […]
[…] Invitation and roundup from Ken Fisher. […]
[…] Fisher (b|t – #85 – December […]