Create a copy of database

Dear all,
From SQL Enterprise Manager, how to create a copy of existing database ?
i.e. there is a database called GL2005 and I want a copy of GL2005 with the
name called GL2006.
Thanks.
Vensia1. backup/restore
2. deattach, copy files, attach
3. Use DTS or SSIS (depending upon version)
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23S$lcr1DGHA.2924@.tk2msftngp13.phx.gbl...
> Dear all,
> From SQL Enterprise Manager, how to create a copy of existing database ?
> i.e. there is a database called GL2005 and I want a copy of GL2005 with
> the
> name called GL2006.
> Thanks.
> Vensia
>|||Hi
You may want to check out the following articles that describe the
techniques Mike has suggested
http://support.microsoft.com/kb/304692/ if using backup/restore you will
need to use the MOVE option to change the file names for the new database
http://support.microsoft.com/kb/221465/
If you are using detach/attach the existing database will be offline while
you copy the files and you will need to attach the original database as well
as the new one:
http://support.microsoft.com/kb/224...122120121120120
Both of these methods would not remove the data in any way, and any
subsequent changes to the old database will not be reflected in the new one
(and vice-versa), therefore you may be only required to take the backup and
save it. (after checking that the backup has worked!).
John
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23S$lcr1DGHA.2924@.tk2msftngp13.phx.gbl...
> Dear all,
> From SQL Enterprise Manager, how to create a copy of existing database ?
> i.e. there is a database called GL2005 and I want a copy of GL2005 with
> the
> name called GL2006.
> Thanks.
> Vensia
>|||John & Michael,
Thanks for helping.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:O8LupD4DGHA.2380@.TK2MSFTNGP12.phx.gbl...
> Hi
> You may want to check out the following articles that describe the
> techniques Mike has suggested
> http://support.microsoft.com/kb/304692/ if using backup/restore you will
> need to use the MOVE option to change the file names for the new database
> http://support.microsoft.com/kb/221465/
> If you are using detach/attach the existing database will be offline while
> you copy the files and you will need to attach the original database as
well
> as the new one:
> http://support.microsoft.com/kb/224...122120121120120
> Both of these methods would not remove the data in any way, and any
> subsequent changes to the old database will not be reflected in the new
one
> (and vice-versa), therefore you may be only required to take the backup
and
> save it. (after checking that the backup has worked!).
> John
> "Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
> news:%23S$lcr1DGHA.2924@.tk2msftngp13.phx.gbl...
>