[dba-SQLServer] Duplicate a Database

Robert L. Stewart robert at webedb.com
Mon Aug 4 15:09:51 CDT 2008


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


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
>Within Management Studio, I can't see how to do that.
>Is this possible?
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>End of dba-SQLServer Digest, Vol 66, Issue 1

More information about the dba-SQLServer mailing list