I need to do some research to automate the backups and restore sequences of some SQL Servers.
Here are some links and notes to get started:
- Script to Backup SQL Server Log Files.
Links to Ola scripts, and explains the difference betweeen those and the built-in Maintenance Plans:
– SQL Server Backup.
– http://ola.hallengren.com/scripts/DatabaseBackup.sql - Create database maintenance plans in SQL Server 2005 using SSIS | TechRepublic. Read the rest of this entry »





