SSIS package for automated database backups

Common task for database administrator is to maintain backups of databases.
I created SSIS package which can be used as a basement for daily automated backups. This package can be easily modified to any database and added as step in agent job.

This package was created on MS SQL server 2005 SP3 developer (Visual studio is included in installation)
Please note that advanced backup management is available via 3rd party products (native compression introduced in SQL Server 2008 Enterprise). If you have large production databases I would recommend using tape library or other backup scenarios.

Continue reading “SSIS package for automated database backups”