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 |
anjali5
Posting Yak Master
121 Posts |
Posted - 2013-07-11 : 01:05:15
|
Hi All,I want to make a, I want to make an exact replica of one database in sql server 2005 express edition so I have a database called dbTest and I want to create a database called dbTest2 that is the exact replica of dbTest. How can I achive this. I am using sql server 2005 express edition.any help will be appreciated. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-11 : 01:07:44
|
easiest way is to take a backup of dbTest and then restore it as dbTest2 and you'll get db as on that point in time with all objects and data.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
anjali5
Posting Yak Master
121 Posts |
Posted - 2013-07-11 : 01:09:36
|
I don't have backup of the database. Is their any other way. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-11 : 01:18:13
|
you can take backup now.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|