Solved

How to reload an archive

Posted on 2007-11-21
3
184 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OPENDATASOURCE 8 39
spx for moving values to new table 5 74
Sql Permission 6 59
What is wrong with the below insert statement. Getting error when executing. 5 33
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 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

10 Experts available now in Live!

Get 1:1 Help Now