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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-09-14 : 05:56:44
|
| Hello friends!I am little bit confused with...We have sql server 2000..and database of size near about 95GB...we have lots of objects near about 400 to 500 on old server (tables,summary tables,lookup tables,views and stored procedures)...recently we decided to make new production server and all the data from old production server is transfer to new one..(because on old server we are getting slow performance due to DTS running,transaction of huge data..) what our plan is to load all data to new server daily once and user will access this new server...but my question which one is better option to do this1) transfering all data by DTS daily or 2) Taking back up (of old server) and restore it to new server daily.T.I.A |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-14 : 06:02:04
|
| If you are transferring all the data rather than doing incrementals then backup/restore would be best.If you to select objects then probably dmo.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-09-14 : 06:46:39
|
| HI NR...thanks for your help...i feel better now....but tell me how much time it will take to backup 95 GB data and restore it again to new server..T.I.A |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-14 : 07:02:39
|
| Depends on your network and hardware.I would allow at least an hour but try it and see.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-09-14 : 07:10:45
|
| thanks nr...i got some direction to move forward :) :) |
|
|
|
|
|
|
Transfering data from old prod server to new one