Tag Archives: administration

A Full Backup Includes Everything (with a caveat)

Posted on December 11, 2013 by way0utwest

Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something is in the database when the data reading portion of the backup concludes, it’s in there. Note that “in there” … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on A Full Backup Includes Everything (with a caveat)

The Future of Auditing

Posted on December 5, 2013 by way0utwest

I was reading Captain’s Share the other day and enjoying a quiet afternoon at home. It’s a science fiction book about one man’s journey in the future as a captain of a space freighter. It’s an interesting series from Nathan Lowell that … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on The Future of Auditing

It Still Happens – Full Transaction Log

Posted on October 17, 2013 by way0utwest

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

Posted on October 1, 2013 by way0utwest

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