Tag Archives: backups
-
SQL Homework – September 2021 – How good is your recovery plan?
Leave a commentSeptember 2, 2021 by Kenneth Fisher
Last month I had you create a security standards document. This month we are going to document our recovery plan. …
Continue reading -
SQL Homework – July 2021 – Log shipping
Leave a commentJuly 1, 2021 by Kenneth Fisher
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy …
Continue reading -
Help! My restore has finished but the database still has a status of recovering.
Leave a commentJanuary 8, 2020 by Kenneth Fisher
I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, …
Continue reading -
DBA Myths: Can a differential backup get bigger than the full backup?
7February 14, 2019 by Kenneth Fisher
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one …
Continue reading -
What’s a differential backup?
2January 23, 2019 by Kenneth Fisher
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently …
Continue reading -
Moving SSISDB is not as easy as it sounds
Leave a commentDecember 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 -
My backup script (where, how, how big, etc.)
5November 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 -
SQL Homework – September 2018 – Backup and Restore continued.
Leave a commentSeptember 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 -
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
2July 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 -
SQL Homework – March 2018 – Recovery Objectives
1March 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
SQL Studies 