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 |
|
racinghart
Starting Member
49 Posts |
 Posted - 2007-02-09 : 12:20:07
|
| so we been running on a decent server now for a couple years. we just bought a new proliant dl380... faster, more ram, etc.are there documents to reference to how to make the move successful?-how to copy the log files and db data files onto the new partitions on the new server.the actual solomon db is on an MSA 1000 and we plan on keeping it there.so far on the new server...-installed sql 2005-dynamics sl 6.5any documentation about taking solomon from old server to new server is greatly appreciated |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-09 : 12:35:27
|
| Here's the easiest way to move from one server to the next:Install SQL Server on the new server using the same paths as was used on the old server.Stop the SQL Server service on both machines.Copy all MDFs, NDFs, and LDFs from the old server to the new server in the same paths.Start the SQL Server service on the new machine.This method copies over all DTS packages, logins, jobs, etc... as the system databases were copied over as well.Tara Kizer |
 |
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-02-09 : 15:26:29
|
quote:
Originally posted by tkizer
Here's the easiest way to move from one server to the next:Install SQL Server on the new server using the same paths as was used on the old server.Stop the SQL Server service on both machines.Copy all MDFs, NDFs, and LDFs from the old server to the new server in the same paths.Start the SQL Server service on the new machine.This method copies over all DTS packages, logins, jobs, etc... as the system databases were copied over as well.Tara Kizer
ahh yes... okay... now the 2nd part to this... what if on our old server the mdfs and ldfs are together in the same path but on our new server we were hoping to separate the two data types on different partitions; e.g. ldfs on new servers drive e: and mdfs on drive f: |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
need help moving dynamics sl to new server