[dba-SQLServer] Duplicate a Database

Dan,

The simplest way is to backup the current database.
Then restore it as the new name that you want.


Robert

At 12:00 PM 8/4/2008, you wrote:

>Date: Mon, 4 Aug 2008 11:44:54 -0500
>From: "Dan Waters" <dwaters at usinternet.com>
>Subject: [dba-SQLServer] Duplicate a Database
>To: "SQL Server List" <dba-sqlserver at databaseadvisors.com>
>Message-ID: <584F1C1E1E4E4E18BBCD2A5D2662B5F0 at danwaters>
>Content-Type: text/plain;       charset="us-ascii"
>
>I'm using SQL Express, and have one database.  I'd like to duplicate that
>database inside the same SQL instance and give the duplicate a different
>name.
>
>Within Management Studio, I can't see how to do that.
>
>Is this possible?
>
>Dan
>
>
>
>
>------------------------------
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>
>
>End of dba-SQLServer Digest, Vol 66, Issue 1
>********************************************