Category Archives: Backups
-
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 -
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 -
Copying an on-premise Database to an Azure SQL Database
4August 24, 2016 by Kenneth Fisher
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud. …
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
SQL Studies 