December 15, 2003 at 9:54 am
If I backup and restore the MSDB database will it restore the DTS packages also.
December 15, 2003 at 10:02 am
Yes it should. However, for the future I would save them to .dts files and use some version control software to manage development.
Steve Hughes
Magenic Technologies
December 16, 2003 at 6:17 am
If you have custom DTS tasks, the backup and restore will affect the package definition, but will of course not include the custom DLL files. Restoring an old MSDB backup could result in a mis-match between the package definition and the DLLs.
All information provided is a personal opinion that may not match reality.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply