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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-11 : 09:25:05
|
| Alaa writes "I installed SQL 2000 SP3a in windows server 2003 SP1 on the C Drive on a test Server with a database called "Test", i was working on this test server for a month.Now i want to move these data on a new server Called "Test2" on D Drive instead of C where SQl 2000 installed in D drive in the New Server(Test2).The new server als have windows server 2003 SP1how can i make this process successful.i tried to do many things to let the new server work with the old data (i.e Test Data) i cannot succeedhelp me pleaseSQl 2000 SP3awindows server 2003 SP1" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-08-11 : 11:52:55
|
| how do you plan to move the data? you can try the following:1. bcp out the data and bcp in2. use dts to export the data3. use linked servers to directly exportI usually employ #2 for quick transfersHTH--------------------keeping it simple... |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-11 : 11:56:59
|
| Hi jen,Isn't it a better (less complicated and all objects r selected) to use Backup - Restore ?Srinika |
|
|
|
|
|
|
Moving SQL Database