August 5, 2004 at 2:00 am
Hello all,
I am new to SQL Server and now find myself needing to Back it up.
We are using SQL Server Enterprise Manager Version 8. The product has been installed using all defaults. I need to know where on the server, the Data Transformation Services Local Packages are kept so that I can back them up.
Please forgive me if this is a simple question, as I said I know nothing about Sql Server and now I find myself having to backup just this directory as we do not need to whole server backed up.
It seems to appear within the SQL Enterprise Manager as though it is a directory, however as for as searching the sevrer this directory does not exist. From what I have been reading it saved this location as a msdb file somewhere.
Please any advice would be greatly appreciated.
Thanks in advance
Stephen
August 5, 2004 at 9:49 am
DTS Packages are stored in the sysdts tables in the msdb database. You can backup that database or you can save each DTS package as a Structured Storage File.
-Kevin Williams
August 5, 2004 at 8:49 pm
August 6, 2004 at 7:00 am
In addition to backing up msdb, however, which backs up all of them, I strongly recommend you back each package up as a structured storage file to a folder that is then backed up. This would allow you to recover an individual package.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply