• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

How Do You Copy a MS SQL Database ?

How do you copy a SQL Server Database from one location to another using Microsoft SQL Server 2008?

Thanks,

Dan
0
danielolorenz
Asked:
danielolorenz
3 Solutions
 
sammySeltzerCommented:
You detach it from one db (server) and reattach it from another Pc.

See this link:
http://www.programmersheaven.com/mb/sql-server/322263/322263/moving-the-database-to-another-sql-server/

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

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

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

Thanks,

Dan
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Chris MangusDatabase AdministratorCommented:
You can backup and restore to the other server, or alternatively, you could use the Copy Database wizard.
0
 
danielolorenzAuthor Commented:
Okay, yes I will use the copy database wizard
0
 
Umesh_MadapCommented:
if you want to move only tables and views you can use export and import option for moving the objects

this also one option.
0
 
Alpesh PatelAssistant ConsultantCommented:
Its' good to take back up of database move to the another server and restore it.
0
 
Ramesh Babu VavillaCommented:
you can use the below ways to copy the db
1. detatch the db and attach at destination
2. take a full backuip and restore
3.generate the scripts and execute the script at the destination
0
 
danielolorenzAuthor Commented:
Great Help
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now