Solved

to copy a database

Posted on 2009-04-06
5
198 Views
Last Modified: 2012-05-06
a user wants to me to copy the named X database from a sql server 2000 to anohter server 2005..he says to me " you should copy the server1/ x database to server1/ y database and to server1/ z database..how can 1 copy a database on  a server to inside another databases on another server?
0
Comment
Question by:teodor76
  • 3
5 Comments
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 400 total points
ID: 24075382
use the Copy Database Wizard which eases your requirement.

http://msdn.microsoft.com/en-us/library/ms188664(SQL.90).aspx

In order to obtain the wizard, Right click your Database in SSMS and then choose Tasks --> Copy Database
0
 
LVL 10

Assisted Solution

by:Espavo
Espavo earned 100 total points
ID: 24075398
Another method that I've used is to BackUp the database on the one server, then Restore the DB on the next server... (The copy wizard didn't work for me...)
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 400 total points
ID: 24075416
If Copy Database Wizard doesn't works fine, then the other possible options to do that are :

1. Backup the Source Database and Restore it in Destination Database ( As Espavo mentioned).
2. Copy the MDF and LDF files from Source Database and then Attach those files in Destination Database.
0
 

Author Comment

by:teodor76
ID: 24076046
do I need to copy the mdf and ldf files from source database and then attach in destination files when I backup the source database and restore it in destination database..
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 400 total points
ID: 24076075
When you do a Backup on a database, you will obtain a *.bak file. You need to restore that *.bak file into the destination server.

If you want to copy the database from a live server, copy the MDF and LDF of that server and use Attach option in the destination server to attach the Files into that database.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
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…

839 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