Backing Up and Restoring Packages
SQL Server 2005 Integration Services (SSIS) packages can be saved to the file system or msdb, a SQL Server system database. Packages saved to msdb can be backed up and restored using SQL Server backup and restore features.
For more information about backing up and restoring the msdb database, click one of the following topics:
- Backing Up and Restoring Databases in SQL Server
- Considerations for Backing Up and Restoring System Databases
- Considerations for Backing Up the model and msdb Databases
Any configuration files that the packages include are stored in the file system. These files are not backed up when you back up the msdb database; therefore, you should make sure that the configuration files are backed up regularly as part of your plan for securing packages saved to msdb. To include configurations in the backup of the msdb database, you should consider using the SQL Server configuration type instead of file-based configurations.
The backup of packages that are saved to the file system should be included in the plan for backing up the file system of the server. The Integration Services service configuration file, which has the default name MsDtsSrvr.ini.xml, lists the folders on the server that the service monitors. You should make sure these folders are backed up. Additionally, packages may be stored in other folders on the server and you should make sure to include these folders in the backup.
Integration Services includes the dtutil command-prompt utility, which you can use to manage packages. For more information, see dtutil Utility.
See Also
Other Resources
Administering Integration Services