Our data center recently backed my SQL server to install new hard drives.
Upon restore I noticed that all my DTS's and Job's are missing. When I
brought this to the Datacenters attention , they stated that all data was
successfully restored from tape.

They are no asking be for the file names so they can check the tape.

Are DTS's and jobs stored in separate file on disk? If so, can you provide
me with the path/s and file extensions?

Did they restore all of the databases? All of the job and DTS information
is stored in the msdb database. I think if they backed up the msdb database,
you can restore that database into the current one, you will just need to
turn off the SQL Agent before the restore.

"Gary" wrote:

Providing you store Packages on SQL Server then they are stored in MSDB as
are your jobs.

You can restore MSDB easily.

http://msdn.microsoft.com/library/de...kprst_2w1f.asp


"Gary" <Gary (AT) discussions (DOT) microsoft.com> wrote

Thank you for your response, my packages were recovered.

I do have another issue though. All scripts that reference a UNC path on
the same server, to import text files, are returning an access denied error
5. The server host name is correct (svc-cr) and I am able to map drives to
thes server.

Any idea??

"JLFleming" wrote: