Copy Database on same machine

[Andy Visniewski]

How would I copy an entire database to another (using a different
name, of course) on the same server? I am new with working with
databases, so any help would be appreciated. Thanks.

[John Bell]

"Andy Visniewski" <an**@pepperell.net> wrote in message
news:f6**************************@posting.google.c om...

How would I copy an entire database to another (using a different
name, of course) on the same server? I am new with working with
databases, so any help would be appreciated. Thanks.

[John Bell]

Hi

You could backup/restore or detach/attach

http://support.microsoft.com/default...-us;Q314546#10

With the backup/restore you will have to move the data files (WITH MOVE),
with detach/attach they will have to be copied at OS level.

As they are on the same machine you don't need to worry about
logins/orphaned users.

John

"Andy Visniewski" <an**@pepperell.net> wrote in message
news:f6**************************@posting.google.c om...

How would I copy an entire database to another (using a different
name, of course) on the same server? I am new with working with
databases, so any help would be appreciated. Thanks.

[Trevor Best]

On 2 Sep 2003 11:46:11 -0700 in comp.databases.ms-sqlserver,
an**@pepperell.net (Andy Visniewski) wrote:

How would I copy an entire database to another (using a different
name, of course) on the same server? I am new with working with
databases, so any help would be appreciated. Thanks.

DTS (Enterprise Manager, highlight database, right click, all tasks,
export) Create a new one when prompted on target, use same server.
When you get to a page in the wizard with 3 radio buttons, choose the
bottom one, copy SQL Server objects.

or Again, in the same place, right click, all tasks, backup, backup to
a file. Now in the same place again, choose Restore from the all tasks
menu, the default is to show backups of the currently highlighted
database, which is what you want, at the top of this dialog, type in a
different name for "restore as database...".

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)