[dba-SQLServer] copy a database

Dan Waters dwaters at usinternet.com
Mon Jan 12 15:25:18 CST 2009


There is a method called Detach and Reattach.  It's in SS Help.

Dan

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: Monday, January 12, 2009 3:19 PM
To: SQLList
Subject: [dba-SQLServer] copy a database

I need a demo database and it would be so easy if I could just copy 
AdventureWorks to the SAME server and rename it, but I can't seem to do 
that. I don't have the Copy Wizard either.

Any help?

In the end, I'll probably just create a new database and populate a few 
tables for the demo, but seems like too much work -- should be simpler.

Susan H. 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list