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