Some links for scripting SQL Server Backups and setting up maintenance plans
Posted by jpluimers on 2013/10/30
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.
- Help! My SQL Server Log File is too big!!! | TechRepublic.
- Merrill Aldrich : Hole in your Backup Sequence?.
- How can I delete SQL Server differential and log backups earlier than the earliest full backup still on disk? – Server Fault.
- Simple script to backup all SQL Server databases.
- Automating Transaction Log Backups for All SQL Server Databases.
- Transaction log backup vs. Tail-log backup.
- tran log backup confused 2.5gb log file but 70gb log backup size.
- Reorganize and Rebuild Indexes.
- “BACKUP DATABASE is terminating abnormally.” 3013 9002
- sql sever 2005 shrink log files script
- sql server force shrink log after full backup – Google Search.
- Backup Log with Truncate_Only is Like a Bear Trap | SQLServerPedia.
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment