Re: restore DTS from a backup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


What I would do is to install a temporary SQL Server instance and restore
the msdb database to this instance. Since the DTS packages are saved in this
database now you can see the DTS packages and save them into your original
installation. After you copy and test the required DTS packages you can now
delete the temporary SQL Server instance.

Ben Nevarez


"00090" <706507N@xxxxxxxxxxxxx> wrote in message
news:Xns9712EC0CE84290140507NA02619@xxxxxxxxxxxxxxxx
> hi everybody,
>
> I have make a backup of the MSQL directories
> (with master.mdb, distmdl.ldf, msdbdata.mdf and other files & directories)
>
>
> now, I need to restore the DTS from the backup because I lost them from my
> instance database
>
> how can I install a copy the backup files and extract the dts in order to
> install then again on the original database ?
>
>
> many thanks in advance for your help
>


.

Relevant Pages

  • Re: Shall I install SQL on each machine + VB.Net Application
    ... You'll have to have a SQL server instance available in one way or the other. ... the database is best placed on a server. ... compulsory to install the SQL Server on his machine? ...
    (microsoft.public.sqlserver.server)
  • 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: Need help with DTS Package Maintenance
    ... You can create DTS packages in VB, ... > source Interbase Database and I make a SQL Server connection to the target ...
    (microsoft.public.sqlserver.dts)
  • Re: Installing SQL Server 2005 on a PC that has Visual Studio 2008
    ... When I installed SQL 2005's SSIS, it automatically installed a standalone version of VS2005. ... After I had saved the packages once, the icons stayed visible and the error ... Install the special web download 'SQL Server 2000 DTS Designer ... There is no 64-bit design-time or run-time support for DTS packages. ...
    (microsoft.public.sqlserver.clients)
  • Re: Standard Method for Importing/Exporting to DB
    ... the database name, server name, and filename+fullpath. ... and also exporting to CSV files. ... everything from DTS packages to Crystal Reports are used. ...
    (microsoft.public.dotnet.languages.vb)