Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 My question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-07 : 09:06:46
yogesh writes "How can I copy a database to create new database in same sql server.

Suppose i have a database named MyDatabase and I want to copy that databse along with data to new database named MyDatabse2.How can I do it>"

mr_mist
Grunnio

1870 Posts

Posted - 2004-09-07 : 09:21:43
Backup and restore with a different database name.


-------
Moo. :)
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-09-08 : 13:01:11
also..
create a blank DB by name MyDatabse2. Import the DB using DTS.


------------------------
I think, therefore I am
Go to Top of Page
   

- Advertisement -