File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come across File Group backups implemented in production the database is using the full recovery model. With the full recovery model you can specify individual file groups for backup. A very common backup strategy for VLDB’s […]
Category: Backups/Recovery
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these reviews, one of the many checks I perform is reviewing backup history and making sure that the backup plans in place meet the requirements and service level agreements for the business. I have found a […]
Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the recovery models, recovery point objectives and recovery time objectives. What I have found from speaking at many SQL Saturday’s and User Groups is that most DBA’s do not regularly practice recovery strategies. It is very […]
How to break a high end de-duplication backup device
I have been working with a client recently who purchased a nice top of the line de-duplication backup device in order to synchronize backups between two data centers. This device is very nice in how it will de-duplicate data to reduce storage needs and also compress the data. It will then synchronize the data to […]
SQL Backup and Recovery – new distribution
I recieved an email today from my publisher Joes 2 Pros that my book was now available on Barnes and Noble’s website in addition to Amazon in print and Kindle. This is very exciting. In just three months SQL Backup and Recovery has sold nearly 500 copies. I am still in awe that my name […]
PASS Summit 2012 – Networking
I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle Washington and attended the largest Microsoft SQL Server convention in the world. My first year was all about attending sessions and learning new things. Year two was about attending technical sessions and hanging out with […]
Scripting out users
Many of us know the importance of scripting out our users on a regular bases in order to be able to before DR restores more efficiently. If you are responsible for performing backup and restores or disaster recovery solutions and you do not have a routine to regularly script out your users and permissions, then […]
SQL Backup and Recovery
I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very important to me. As database professionals, few things are more important than being able to properly backup and recover our data. I had put together a presentation for user groups and SQL Saturday’s titled “Know […]