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 |
|
shaankit
Starting Member
4 Posts |
 Posted - 2003-03-03 : 10:24:31
|
| Hello,We are in the process of moving all the databases from one server to another. What should I be concerned with.I have read this linkhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071 and it seems to be very useful.If there are any other issues I need to concerned of please let me know.The second question I have is we have almost a 100 DTS jobs that are currently running on this old server. How will these DTS jobs be affected when we move to the new server. Thanks in advance.Shaan |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
shaankit
Starting Member
4 Posts |
Posted - 2003-03-11 : 10:54:28
|
| Thanks Franco,I will go through the information you have given. Is there anything else I need to be aware of? Thanks again.Shaan |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-11 : 13:32:22
|
| The article that you mentioned is only to be used if you are just wanting to move the files around on the same server. To move the user databases from one server to another, simply detach the files, copy the files over to the new server, then attach them. You will then want to move your DTS packages, logins and passwords using the articles that Franco mentioned. You also need to move your jobs. To do this, you can siply right-click on each of the jobs and generate the script. Then run the script on the destination server to add the job(s).Tara |
|
|
|
|
|
|
Moving from One server to another