Copying database to new name on same server

Dear Y'all -
I'm a newbie to this list. I have a database of about 2Gb that I need
to duplicate several times, giving each duplicate a new name, on to a
single server. Sounds simple is proving to not be so. The basic
export command seems to do what I want but it runs for longer than I'm
willing to wait, over 6 hours. It takes less than an hour to create
the database from scratch.
Is there something I'm missing? Is there a way to duplicate a
database at the file system level and them update the DBMS system
tables (or whatever) so the new files are recognized properly.
TIA.
Yours - Billy
============================================================ William Goedicke goedicke@.goedsole.com
http://www.goedsole.com:8080
============================================================
Lest we forget:
Don't force it; get a bigger hammer.
- Al DodgeDo a backup once, then do multiple restores (during a restore you can
specify a new name, and it will take care of data file names etc. as well).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"William Goedicke" <wgoedick@.reveregroup.com> wrote in message
news:m38ylcofqg.fsf@.mail.goedsole.com...
> Dear Y'all -
> I'm a newbie to this list. I have a database of about 2Gb that I need
> to duplicate several times, giving each duplicate a new name, on to a
> single server. Sounds simple is proving to not be so. The basic
> export command seems to do what I want but it runs for longer than I'm
> willing to wait, over 6 hours. It takes less than an hour to create
> the database from scratch.
> Is there something I'm missing? Is there a way to duplicate a
> database at the file system level and them update the DBMS system
> tables (or whatever) so the new files are recognized properly.
> TIA.
> Yours - Billy
> ============================================================> William Goedicke goedicke@.goedsole.com
> http://www.goedsole.com:8080
> ============================================================> Lest we forget:
> Don't force it; get a bigger hammer.
> - Al Dodge|||When you do the restores you will need to specify new paths for the data nd
lof files as well. You can do this in Enterprise Manager or use the WITH
MOVE option in Query Analyzer.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||In my last post it should have been:
When you do the restores you will need to specify new paths for the data
and
log files as well. You can do this in Enterprise Manager or use the WITH
MOVE option in Query Analyzer.
This posting is provided "as is" with no warranties and confers no rights.|||If you use EM for the restore, the filenames get changed wrt the new name
automatically, at least in my experience.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
news:rD7WE2KxDHA.3660@.cpmsftngxa07.phx.gbl...
> When you do the restores you will need to specify new paths for the data
nd
> lof files as well. You can do this in Enterprise Manager or use the WITH
> MOVE option in Query Analyzer.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>