Copying DB withing the same server

#1

What is the fastest way to make a copy of a database.
Let's say, I have a database call my_db and I want to
recreate the same database and called my_db2. This is all
in the same server. Thanks in advance for any help. Sandra

#2

BACKUP and RESTORE for me is the best way of doing this

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sandra" <silvah (AT) wellsfargo (DOT) com> wrote

Quote:

What is the fastest way to make a copy of a database.
Let's say, I have a database call my_db and I want to
recreate the same database and called my_db2. This is all
in the same server. Thanks in advance for any help. Sandra

#3

Quote:

-----Original Message-----
Using backup and restore is a very good way to get a
duplicate copy of a database. Using the DTS Export turns
views into tables, so this is definitely preferable.
Thanks for the great tip!
.

Actually I used the DTS and it did not turned the view
into tables. However I like the back and restored strategy
better.

Thanks everyone!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Copying DB withing the same server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Copying DB withing the same server - 10-01-2003 , 08:44 PM

Re: Copying DB withing the same server - 10-02-2003 , 01:19 AM

Re: Copying DB withing the same server - 10-02-2003 , 03:03 PM