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 |
|
gagani
Posting Yak Master
112 Posts |
 Posted - 2012-06-14 : 06:08:11
|
| I want to create a new database in sql 2000 which is exactly like the other. I want all the tables with values, stored procedures, everything in one database to present in the new database.Could anyone help me with this soon. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-06-14 : 06:15:29
|
| Take a backup and restore in a new database.Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
|
|
|
new database(exact replica of the other) in sql