Tag Archives: backups
-
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 -
Backups of backups or How long is my backup really available?
1February 7, 2018 by Kenneth Fisher
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, …
Continue reading -
Schema only backup or schema only DB copy
Leave a commentOctober 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 -
SQL Homework – July 2017
11July 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 -
Backup to NUL
14June 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 -
Compressed backup errors and TF 3042
6March 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 -
What’s in my backup file?
Leave a commentFebruary 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 -
What is COPY_ONLY?
4January 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 -
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
Leave a commentDecember 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 -
DBA Myths: You can only restore one differential backup
4December 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
SQL Studies 