Backing Up and Restoring Packages
This page is specific to: Version:SQL Server 2005
SQL Server 2005 Books Online (November 2008)
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:

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

Help and Information

Getting SQL Server 2005 Assistance
© 2009 Microsoft Corporation. All rights reserved.   Terms of Use | Trademarks | Privacy Statement
Page view tracker
Rate the Lightweight library
x
Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.
Do you like the SearchBox?
Do you like the tabbed code blocks?
How useful is this topic?
Tell us more.
Thanks
x
You're helping to improve MSDN Online.
Feedback
Switch View
Classic
Lightweight Beta
ScriptFree
Switch View