Tag Archives: Backup/Recovery

Recovery Models

Posted on September 26, 2011 by way0utwest

In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases use the defaults, which mean that they are in the full recovery model. In that case, you need to be … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Recovery Models

SQL Server Backups – When is it current?

Posted on September 1, 2011 by way0utwest

I saw a post recently where someone was asking about the restore sequence for a series of backups. The scenario was this: Full backup starts at 3:00am, and takes 30 minutes Log backup 1 starts at 3:05am, and takes 2 … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Server Backups – When is it current?

Create a Log Backup Schedule – #1 Skill You Need

Posted on August 25, 2011 by way0utwest

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. You Need Log Backups By default databases in SQL Server are created with the Full … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on Create a Log Backup Schedule – #1 Skill You Need

When Do You Take a Full Backup?

Posted on August 15, 2011 by way0utwest

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. When is a Full Backup Taken? Most people might answer this with “every day”, or … Continue reading →

Posted in Blog | Tagged , , , , , | 1 Comment