Tag Archives: Backup/Recovery

Transactionally Consistent

What does this mean? I had someone ask me in a session recently, and I think I have a good explanation, but I thought this was worth a blog. Transactionally Consistent means that there is a snapshot of the database … Continue reading

Posted in Blog | Tagged , , | Comments Off on Transactionally Consistent

Risky Backups

This editorial was originally published on Jan 13, 2009. It is being re-run as Steve is away at the SQL Intersection conference. The other day I was working in the forums at SQLServerCentral and saw a question about someone doing backups and … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Risky Backups

It Still Happens – Full Transaction Log

Probably the most often asked question on SSC is about full transaction logs, and often full disks. It happened again recently. I don’t have an exact count of threads, but rough searches show this to have 70,000+ results, when most … Continue reading

Posted in Blog | Tagged , , , | Comments Off on It Still Happens – Full Transaction Log

The Need for Tape

This editorial was originally published on Mar 26, 2009. It is being re-run as Steve is away at DevConnections. One of our SQLServerCentral authors sent me this post, which I found to be pretty amazing. Apparently hackers broke into a backup server at … Continue reading

Posted in Editorial | Tagged , , , | Comments Off on The Need for Tape