Tag Archives: Backup/Recovery

Data Worms

Posted on September 20, 2012 by way0utwest

Effective data administration include backups. I would argue this is the most important part of managing your data since no matter what happens, backups give you the ability to recover your system. Whether it’s an accidental data modification by a … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Data Worms

Make a Backup First

Posted on August 22, 2012 by way0utwest

I was reading in detail about the Apple / Amazon hack that targeted a Gizmodo writer.  A hacker used a few techniques to get from his Amazon account to his Apple account, his GMail, Twitter, and more. His iPhone, iPad, and Macbook … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Make a Backup First

Always restore with NORECOVERY

Posted on May 24, 2012 by way0utwest

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option. It’s trivial to switch the database online. Not trivial to recover from an accidental restore with RECOVERY (the default) ‘nuff said.

Posted in Blog | Tagged , , , | 5 Comments

You need to run DBCC CheckDB regularly

Posted on April 30, 2012 by way0utwest

You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware problem or driver issue. Corruptions don’t disappear and you can’t necessarily Corruptions can be caused by numerous factors, and it … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on You need to run DBCC CheckDB regularly