<div>
Try this:<br />
<a href="https://www.experts-exchange.com/questions/20585066/Restore-re-attach-of-MSDB-to-a-recovered-server.html" rel="ugc">https://www.experts-exchange.com/questions/20585066/Restore-re-attach-of-MSDB-to-a-recovered-server.html</a>
</div>


Try this:
https://www.experts-exchange.com/questions/20585066/Restore-re-attach-of-MSDB-to-a-recovered-server.html [https://www.experts-exchange.com/questions/20585066/Restore-re-attach-of-MSDB-to-a-recovered-server.html]

<div>
Attach it as a different database. &nbsp;You need not keep the DB name the same when attaching. &nbsp;Try:<br />
<br />
sp_attach_single_file_db 'OldMSDBData', 'C:\OldData\msdbdata.mdf'<br />
<br />
Once it is attached, you can *try* to get the info from the old sysdtspackages table to the new one. &nbsp;You will probably need to turn on inserts to system tables, though.<br />
<br />

</div>


Attach it as a different database.  You need not keep the DB name the same when attaching.  Try:

sp_attach_single_file_db 'OldMSDBData', 'C:\OldData\msdbdata.mdf'

Once it is attached, you can *try* to get the info from the old sysdtspackages table to the new one.  You will probably need to turn on inserts to system tables, though.



<div>
the last entry help the best; i attempted options #1 and #2 with no personal success, but #3 seems to have worked.<br />
thanks!
</div>


the last entry help the best; i attempted options #1 and #2 with no personal success, but #3 seems to have worked.
thanks!

<div>
<div class="content wysiwyg-content">
SQL 7.0<br />
Win2K Server<br />
<br />
situation:<br />
power supply burned out motherboard &amp;&nbsp;tape drive, rendered machine and drives useless<br />
retrieved all MDFs and LDFs from drives<br />
<br />
acquired new machine, but could not get old drives to work with new board<br />
thus got new drives witha new install of Win2K Server &amp;&nbsp;SQL7<br />
<br />
was able to successfully reattach all MDFs and LDFs<br />
BUT all DTS packages were local (and thus in msdb)<br />
<br />
so I have msdbdata.mdf from old machine/drives and need to retrieve the DTS packages. &nbsp;Any way I can do this? &nbsp;
</div>
</div>


SQL 7.0
Win2K Server

situation:
power supply burned out motherboard & tape drive, rendered machine and drives useless
retrieved all MDFs and LDFs from drives

acquired new machine, but could not get old drives to work with new board
thus got new drives witha new install of Win2K Server & SQL7

was able to successfully reattach all MDFs and LDFs
BUT all DTS packages were local (and thus in msdb)

so I have msdbdata.mdf from old machine/drives and need to retrieve the DTS packages.  Any way I can do this?  

can I salvage DTS local packages from msdbdata.mdf?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.