[dba-SQLServer] copy a database

Well, that sounds easy enough -- I knew there had to be an easy solution and 
that I was just making it too hard. Thanks!

Susan H.


> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>