<div>
<div class="content wysiwyg-content">
Hello,<br />
Background:<br />
We have production servers that run sql 2005 and we have created an archive from our main database.<br />
We are now downloading both the archive and main database to our lan for development purposes. &nbsp;<br />
<br />
Question:<br />
Rather then restore two databases on our lan, Is there a way in sql 2005 &nbsp;to &quot;reattach&quot; the archive to the main database so we can restore one large database?? <br />
Sorry - I am a newbie to Sql and am not up on correct terminology.<br />
Thanks
</div>
</div>


Hello,
Background:
We have production servers that run sql 2005 and we have created an archive from our main database.
We are now downloading both the archive and main database to our lan for development purposes.  

Question:
Rather then restore two databases on our lan, Is there a way in sql 2005  to "reattach" the archive to the main database so we can restore one large database?? 
Sorry - I am a newbie to Sql and am not up on correct terminology.
Thanks

How to reload an archive

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.