Category Archives: Backups
-
The tail of the log
Leave a commentAugust 24, 2015 by Kenneth Fisher
A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I …
Continue reading -
Copying a TDE database from one instance to another
12June 22, 2015 by Kenneth Fisher
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
Continue reading -
TSQL Tuesday #66: Monitoring
2May 12, 2015 by Kenneth Fisher
If a user is going to call me about problem, I’d much rather know about it ahead of time. In …
Continue reading -
Backup before you restore
4April 22, 2015 by Kenneth Fisher
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back …
Continue reading -
Make sure you back up the Service Master Key
6April 8, 2015 by Kenneth Fisher
I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master …
Continue reading -
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
5January 5, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading -
Playing with the log – VLF order while growing the log
1December 17, 2014 by Kenneth Fisher
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of …
Continue reading -
Playing with the log – Before the first full backup
1October 29, 2014 by Kenneth Fisher
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
Continue reading -
Database default locations
4September 29, 2014 by Kenneth Fisher
One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
Continue reading -
Generating a restore script
9August 18, 2014 by Kenneth Fisher
In order to speed up our backups on a large database our team decided to stripe the backup files. In …
Continue reading
SQL Studies 