[dba-SQLServer] copy a database

kens.programming kens.programming at verizon.net
Mon Jan 12 15:27:46 CST 2009


Susan,

When I want a copy of an existing database, I just use the backup of the
existing database and restore it under a different name.  I do this all the
time.

Ken

-----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 1: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