We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How Do You Copy a MS SQL Database ?

Medium Priority
197 Views
Last Modified: 2012-05-11
How do you copy a SQL Server Database from one location to another using Microsoft SQL Server 2008?

Thanks,

Dan
Comment
Watch Question

Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2011

Commented:
One more link if you wish to use tsql sp_attach and sp_detach syntaces.

http://support.microsoft.com/kb/224071

Author

Commented:
Thanks.  Does this not just move the database?  How do you make just a copy of the database?  

Thanks,

Dan
Chris MangusDatabase Administrator
CERTIFIED EXPERT

Commented:
You can backup and restore to the other server, or alternatively, you could use the Copy Database wizard.

Author

Commented:
Okay, yes I will use the copy database wizard
if you want to move only tables and views you can use export and import option for moving the objects

this also one option.
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Great Help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.