Category Archives: Backups/Recovery

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 … Continue reading

Share
Posted in Backups/Recovery, SQLServerPedia Syndication | 1 Comment

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 … Continue reading

Share
Posted in Backups/Recovery, SQLServerPedia Syndication | 5 Comments

Reducing Your Storage Footprint Using SQL Storage Compress

I was asked to speak at SQL in the City in New York and Austin Texas.  I have used many red-gate products in my time as a DBA but was not familiar with SQL Storage Compress until a couple of … Continue reading

Share
Posted in Backups/Recovery | Tagged , , | Leave a comment

When Things That Are Supposed to Protect You Try to Kill You

This past week I was presented with a very unique issue.  A call came in with a production issue on a tier one application.  Unfortunately it was on a system that utilizes SQL 2000 SP4.  Having a rather small toolset … Continue reading

Share
Posted in Backups/Recovery, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of the log for the database has not been backed up? Many times if you are just restoring a database into … Continue reading

Share
Posted in Backups/Recovery, Presentations, Query Tidbits, SQLServerPedia Syndication | Tagged , , , , | 5 Comments

Find the version of the Master DB from a backup

Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database.  Since most folks probably don’t have a routine … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits | Leave a comment

Checking Backups

Over the past two years I have acquired quite a few database servers that I am responsible for.  We have many standards among the database group I am a part of, things such as standard drive configurations (drive for data … Continue reading

Share
Posted in Backups/Recovery | 2 Comments