RE: Recover DTS
"Guido Schauwecker" wrote:
> Hello,
> my sql instance stopped working! I was able to save all the mdf and ldf
> files, but have no idea where the dts are. Please any help will do!!!
The DTS packages are stored in the MSDB database. You can recover it by
restoring the MSDB database. For more details click the link below on how to
restore it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Hope this helps.
.
Relevant Pages
- RE: Recover SQL files & DST packages from server backup
... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database. ...
(microsoft.public.windows.server.sbs) - Re: Viewing DTS package properties and Permissions
... While your suggestion is a good first step, it would not defeat a consultant ... who knows that DTS packages are stored in the msdb database. ... Perhaps addressing the permissions of the msdb database provides additional ... > Another option would be to deny execute permissions on ...
(microsoft.public.sqlserver.security) - backup of DTS packages
... I'm seeking help on system backup for DTS packages, and, information on how ... We have tried backup of the msdb and restoring elsewhere but the DTS ...
(microsoft.public.sqlserver.dts) - Re: Very Very Urgent, Please Help
... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
(microsoft.public.sqlserver.datawarehouse) - guest user in msdb
... dts packages and i donīt want that this users have ... permissions to create it. ... in the msdb database. ... if i this change can cause problems in sql server. ...
(microsoft.public.sqlserver.security) |
|
