An Automatically Executing Database Backup Script
Posted on 2009-05-05
I am new to SQL Server 2005 standard and am trying to catch up and wondering if I can ask assistance from someone in the group. I would like to establish a script that would automatically execute on our database server at various times during the day and perform a full backup of our new database. The naming structure of the backup would be comprised from the database name and a date and time stamp. For example a backup of database "ABC" taken today at 10:00AM would be named "abc0505091000.bak".
My initial aim is that by backing up the database at various times during the day I minimize the amount of loss should we experience a catastrophic failure of the database. Additionally I can copy the above backups to removable media and store them offsite for contingency protection as well.
By the time the system grows to substantial size I can explore alternative methods of protecting the data as well as have a budget to support the plan.
Your suggestions would be greatly appreciated.