Solved

How to reload an archive

Posted on 2007-11-21
3
167 Views
Last Modified: 2010-03-19
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
0
Comment
Question by:hexvader
3 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 63 total points
ID: 20330287
... OK, let's figure out what you have done first.
'archive' is not a SQL Server term. So I think you either created a backup (*.bak) or, you just shut down SQL Server and copied the datafile (*.mdf) and logfile (*.ldf).

I think from your Q, you have a backup.
In the backup, the complete database is available. So all you have to do is restore that database and you are done.

If this is not the case, just tell us what files you have and/or what you have done in more detail and we'll be glad to help you out.

Hope this helps ...
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 62 total points
ID: 20331146
Hi,

I agree with Yveau that 'Archive' is not a SQL Server term, but is common in business apps to take old records and move them to another database.

I believe that you will need either both databases in development, or configure the application to ignore the archive database, ie that the production database is it.

Given my slant on things, this all is application dependant - it depends on what your developers need and what the application can be configured as.

What are the files that you have available?

HTH
  David
0
 

Author Comment

by:hexvader
ID: 20921418
Thanks for your help guys
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now