Solved

How to reload an archive

Posted on 2007-11-21
3
199 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

751 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