Backup Rant
Do you backup production databases? If you do, fantastic. If you don’t, well, cross your fingers and just about everything else and hope that you don’t suffer a failure of any kind!
I read a number of posts in various forums where a database has become corrupt or there is no backup and you get a vast array of answers as to why there is no backup in place. In some cases, you may find that somebody has had the production databases dumped on them because they mentioned that they saw a SQL statement one time. While it’s still not really acceptable that there may be no backup in this scenario, it is understandable. However, if you are in this situation, then I would suggest you read Books on Line and ensure your data is backed up – don’t forget the restores too…A backup is no good if you can’t restore it!
For those full time DBA’s who have no backups, you have no excuse at all. Every DBA should be able to backup and restore databases in a variety of configurations and scenario’s.
I can’t stress enough the importance of backups.
Rant over! I’ll actually put together a series of posts to walk through backups and restores and the various configurations and scenarios.