August 8, 2002 at 9:07 am
For saving and recovering packages:
http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp
links to the save article inside.
Steve Jones
August 9, 2002 at 10:38 am
Steve, if I follow the steps on your document, do you think that I will be able to recover the DTS packages that did not get restored? Thanks.
August 22, 2002 at 12:40 am
Hi..
The packages don't get backed up when you back up the database on which they are created.
The information of/about the packages created are stored in the MSDB database. Hence you should backup this database as well to backup your packages and restore this database in the server where the database is being restored.
There is another way as well. You could save the package as a file and import back to your server.
Good luck
CH.Ravi
Hello everyone,
I restored our databases on a server. Everything looks fine except the local packages were not restored. Doesn't SQL Server restore the packages? Actually I used Veritas Backup Exec 8.6. Any help would be greatly appreciated. Thank you.
[/quote]
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply