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 |
|
swathigardas
Posting Yak Master
149 Posts |
 Posted - 2008-10-31 : 09:40:01
|
| How to make a Copy of the database in same or different sever. The new database created should have all the objects of the old one. How to do this |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-31 : 09:43:56
|
| Make a full backup of current DBRestore current DB with MOVE option. |
 |
|
|
swathigardas
Posting Yak Master
149 Posts |
Posted - 2008-10-31 : 09:44:21
|
| Also can the data also be migrated which is there in the tables of old databse |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-31 : 09:50:48
|
quote:
Originally posted by swathigardas
Also can the data also be migrated which is there in the tables of old databse
YesMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Copy Database