Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....  Read more...

I wonder if you’ve had the situation that I had before where you have to attach a database with one...  Read more...

DB Backup status Details   Read more...

Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.  Read more...

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.  Read more...

You have been doing a fantastic job of late.  You have all of your databases being backed up on a...  Read more...

The most critical task for all DBAs is to have a Backup and Recovery strategy that ensures, every day, that in the event of a disaster they can restore and recover any database, within acceptable limits for data loss and downtime. Even with all the required backups in place, it's easy to miss subtle failings in the overall plan that can, and eventually will, defeat your recovery plans.   Read more...

Developing a backup procedure that makes sure you can do restores should be one of your top priorities as a DBA. In this article Greg Larsen discusses some of the concepts to consider when developing, building and testing a backup strategy.  Read more...

We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...  Read more...

Part of an effective response to a disaster situation is practice and testing of your skills and procedures. Steve Jones reminds us this is important today.  Read more...

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.  Read more...

this script helps you to backup from all database except of sysDatabases  Read more...

This is a quick rewrite of the script I just posted a few days ago.  The script had a few...  Read more...

Grant takes a humorous (but completely serious) look at why you should be regularly verifying your backups. Get top tips for backup and recovery, and protect yourself when disaster strikes. Watch the video  Read more...

Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.  Read more...

Odd Man Out SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood. Let’s...  Read more...

Read more...

5 Second Rule Doesn’t Apply to Dropped Databases or Does It? 5 Second Rule Doesn't Apply to Dropped Databases or Does...  Read more...

The Database Recovery Advisor in SQL Server 2012 will aid the ability of DBAs to recover their databases to a point in time in a crisis. Read about this new feature and how it can speed the process of recovery.  Read more...