RE: Where are my DTS packages
From: Olu Adedeji (OluAdedeji_at_discussions.microsoft.com)
Date: 01/17/05
- Next message: Jürgen Tabert: "run package inside excel macro"
- Previous message: Billy: "Where are my DTS packages"
- In reply to: Billy: "Where are my DTS packages"
- Next in thread: Billy: "RE: Where are my DTS packages"
- Reply: Billy: "RE: Where are my DTS packages"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 Jan 2005 04:55:03 -0800
Your DTS packages in your case are most likely stored in the msdb database.
If you can get a copy of the old msdb database and restore this you will be
able to retrieve your dts packages.
your login information are stored in the master database . . .you need to
restore your master database from a valid backup.
search in KB for 'restore system databases SQL 7'
"Billy" wrote:
> One of my servers needed to be rebuilt recently and a new C drive was
> installed.
>
> SQL Server (7) was lost although the DATA was held on another drive. So I
> installed SQL Server 7 again, on the C drive as a clean install and then
> imported the tables....
>
> But now I seem to have lost all mt DTS packages. I don't know where SQL
> stores them, but they are not visible in the SQL Server Enterprise manager.
>
> I am also having login troubles. Is there anyway I can get my SQL server
> back to the way it was? Are logins and DTS packages\stored procedures etc
> stored in another database? If so, can I delete that database created by the
> fresh install and replace it with the original (e.g. master or tempdb?)?
>
> Thx for replies.
- Next message: Jürgen Tabert: "run package inside excel macro"
- Previous message: Billy: "Where are my DTS packages"
- In reply to: Billy: "Where are my DTS packages"
- Next in thread: Billy: "RE: Where are my DTS packages"
- Reply: Billy: "RE: Where are my DTS packages"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
