Solved

Copying an SQL datatbase

Posted on 2013-05-24
4
154 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
[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
  • 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
 

Author Closing Comment

by:1752
ID: 39193902
Thank You.

I will backup and restore.

Regards
1752
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

617 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