Solved

Copying an SQL datatbase

Posted on 2013-05-24
4
148 Views
Last Modified: 2013-05-24
Dear Experts,

This must be very simple I just want to know the beast way to do it!

I want to copy the sql 2008 database from my dev PC to my server.

Both the dev PC and Server have sql 2008.

What I usually do is detach database copy to the server and attach.

Regards 1752.
0
Comment
Question by:1752
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39193883
please refer below article

http://support.microsoft.com/kb/314546
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 39193886
Firstly read this:

http://stackoverflow.com/questions/610113/sql-server-backup-restore-v-s-detach-attach

Secondly, I personally would do a backup and restore.

Backup the database on the main system, zip the backup and copy to the second machine. In SQL Management Studio, create a new target database if needed and then simply restore the database over the top.
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39193888
0
 

Author Closing Comment

by:1752
ID: 39193902
Thank You.

I will backup and restore.

Regards
1752
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

759 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

17 Experts available now in Live!

Get 1:1 Help Now