Solved

Use copy database wizard or backup and restore on sql server

Posted on 2006-11-22
2
224 Views
Last Modified: 2006-11-22
We are getting a new server and we need to transfer a 15g database to the new one.  What would be the fastest way to do this....using the copy database wizard or doing a backup and restore?  Also can this be done during production or will it have to be after hours?

Thanks
0
Comment
Question by:tbailey922
2 Comments
 
LVL 28

Accepted Solution

by:
imran_fast earned 200 total points
ID: 17995183
>>What would be the fastest way to do this....using the copy database wizard or doing a backup and restore?

detach the databases copy mdf and ldf to the new server and attach them

transfer logins between sql
==========================
http://support.microsoft.com/kb/246133/

second is both sql are same (2005 or 2000)
use copy database wizard

third
backup and restore.

0
 
LVL 20

Assisted Solution

by:Sirees
Sirees earned 50 total points
ID: 17995271
<<Also can this be done during production or will it have to be after hours?>>

You can do backup and restore..

Are you moving production database to another server?

If so, then its always better to do it off  hours. As usual don't forget to take the backup first.


0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 8 55
SqlDataBase 7 46
SQL Improvement  ( Speed) 14 26
How to resolve SQL Server DB deadlock which makes my application hangs ? 6 22
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

786 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