Checking the backups


One of the things that a SQL DBA must do as often as possible is to check the SQL backups. The best will be to check them daily, but to be honest I do not have the time for that. At the moment I use “restore verify only” on a daily basis to check my backups, but that is not enough. My company has two disaster recovery tests per year and these tests are a great opportunity to check my backups. I also try to restore the databases from the core applications at least once a month. If you are a DBA and you are not currently checking your backups, my advice to you will be to start doing it as soon as possible. You don’t want to find out that your backups are corrupt during a disaster!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s