Solved

to copy a database

Posted on 2009-04-06
5
210 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
[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
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Is there any Easy way to copy CSV to SQL Server using C# 3 105
Need help with a query 6 82
How can I exclude some wording in a like statement? 39 82
Sql Server group by 10 56
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

731 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