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.
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.