Printable View
Where are DTS packages stored? Are they stored as a structure file ext or in SQL DB?
Are they backed up with the SQL server? Or do I need to back them up separatly?
What do I need to do for recovery if server failed?
Please advise.
Thank you in advance.
If you have saved the packages in sql server it is stored in msdb..sysdtspackages.
But you could also chose to save the package as a file or in MS repository.
Look in BOL for "Repository SQL Tables" for a list of tables used by repository.
Take backup of MSDB database daily.
Thank you for all your information.
Is there any limitation on how many DTS pacakages can exist in MSDB? Is it limited by the size of the MSDB?
Thanks
That's correct.
try to keep one version for one DTS package so that you can save space and you will know which version you are using.
Thank you for your advice. Do I have to manually maintain the number of versions to keep in the MSDB?
MSDB stores all the versions. you have to manually delete old versions of DTS package if you like to save some space.
everytime you update a DTS package it is saved as a new version. right click on any DTS package and click on 'versions', you can find how many versions you have.