Happy Thanksgiving to all those who celebrate. Todays coupon code is BACK60 As black Friday approaches, we are kicking things off with another great class promotion. My goal is to sell as many classes as I can this month at the lowest price we will set them at all year long. If you are thinking about singing up for one of …

Thanksgiving Special 60% off SQL Server Backup and Restore Read more »

There is an old DBA joke, that goes something like this: You either need to have a good backup strategy, or a really good resume. But all joking aside, many people responsible for a SQL Server database find out too late that they did not have the right backup and recovery strategy. How would it feel to explain to your …

Do you have the right backup and recovery strategy? Read more »

Click here to read Part 1 Click here to read Part 2 Incremental Method This method has a few names and is fairly simple to implement. It involves determining how long you wish to maintain a copy of your data and how many tapes you wish to use. It is based on labeling each backup with a number and then …

Backup Retention – Part 3 of 3 Read more »

So you have a backup for your SQL Server but are you certain it’s good enough for your business needs? Are you 100% sure you’ve configured your backup and restore plan correctly? If you answered No or Maybe to either of these questions you should revisit your backup/plan or freshen up your resume. Yep, it can be dangerous operating a …

Is my SQL backup plan good enough? Read more »

Backup Retention Part 1 Backup Retention Part 3 In part 1 I spoke about why you would want to restore from backups and some other reasons to have an older backup around. In part 2 I will dive more into the specific types of backup retention methods. Part 3 I will define more on methods but also cover combined methods …

Backup Retention – Part 2 of 3 Read more »

Backup Retention Part 2 Backup Retention Part 3 With backup retention times there is always a balance between keeping enough backups and purging those backups quickly to free up space. Some clients I have worked with only keep 2 to 3 days of backups, and others keep multiple years of backups. I generally like to push for something longer term …

Backup Retention – Part 1 of 3 Read more »

Unexpected Flooding

So how about flooding or hurricanes? I live in the United States Pacific Northwest, about as far away from Florida as you can be in the lower 48 United States. So I have not experienced hurricanes, I have only heard stories. But I have seen flooding, there’s a lot of lowland areas where flooding can occur. But this is one …

Backup and Recovery – flooding and hurricanes, are you covered? Read more »

This is something that has really come in the news over the last couple years. A lot of civil unrest. Living in the Pacific Northwest, we heard a lot about what was going on in Seattle, and as Seattle decays businesses are impacted. There was a lot of things happening on Capitol Hill in Seattle last summer or the summer …

Civil unrest – what is your backup strategy? Read more »