Category Archives: Backups/Recovery

#Summit14 Embarcadero Book Signing

The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies to PASS Summit 2014 attendees. You will need to come by booth 224 on Thursday November 6th between 3pm – … Continue reading

Share
Posted in Backups/Recovery | 1 Comment

SQL Server 2014 Backup and Recovery

In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my first two books, however Joes2Pros is focusing its time and energy into video content. When SQL 2014 was released and … Continue reading

Share
Posted in Backups/Recovery | 2 Comments

SQL Server High Availability and Disaster Recovery Options

Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the availability of SQL Server databases.  Questions that always come up when discussing availability of the data is “Recovery Time Objective … Continue reading

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

Know Backups and Know Restores – SQL Server Restores

A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving factor behind me building this session was the response I got from talking to a dozen or so DBA’s about … Continue reading

Share
Posted in Backups/Recovery | Tagged , , , | 7 Comments

The Primary Filegroup Cannot be Backed Up as a File Backup

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

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

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

Share
Posted in Backups/Recovery, Query Tidbits, SQLServerPedia Syndication | 20 Comments

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

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

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

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

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

Share
Posted in Backups/Recovery, SQLServerPedia Syndication | Leave a comment

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

Share
Posted in Backups/Recovery, Presentations, SQLServerPedia Syndication, Training/Events | Tagged , , | 1 Comment