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.
| Author |
Topic |
|
RaghaSM
Yak Posting Veteran
52 Posts |
 Posted - 2009-02-13 : 10:12:48
|
| Hi all,Can any body tell me how to create a duplicate/ copy of an existing databse with data with a differnt name on the same server?eg: My database name is TelephoneDirectory on server1and want to create another database name Telephone on server1 with all the tables,stored procdures,all objects along with data .Please help me. Your help will be very much appreciated.ThanksRagha |
|
|
RaghaSM
Yak Posting Veteran
52 Posts |
Posted - 2009-02-13 : 10:14:22
|
| sorry forgot to mention , we are using SQL server 2000 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 10:50:16
|
| Backup database. Restores that database With different name. Simple. |
|
|
|
|
|
|
How to create a copy of existing database