Tag Archives: backups
-
TSQL Tuesday #85 Invite – Backup and Recovery
40December 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 …
Continue reading -
If backups are taken in silence can a recovery still take place?
3October 11, 2016 by Kenneth Fisher
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a …
Continue reading -
When was this database restored?
6July 27, 2016 by Kenneth Fisher
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. …
Continue reading -
Want to be able to read your database between restores?
Leave a commentJuly 20, 2016 by Kenneth Fisher
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so …
Continue reading -
Database snapshots
4June 22, 2016 by Kenneth Fisher
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
Continue reading -
Help! My backup file has doubled in size.
2June 16, 2016 by Kenneth Fisher
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
Continue reading -
RAID your backups
6May 16, 2016 by Kenneth Fisher
Let’s start with a very brief definition of some RAID levels. RAID 0 : Stripe your data across multiple disks. …
Continue reading -
Changing to simple recovery to clear the log.
6February 10, 2016 by Kenneth Fisher
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries …
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
SQL Studies 