I am planning to move my SQL database off the AMS server to a dedicated SQL server and at the same time move from SQL Express 2005 to SQL 2005.
Could anyone point me in the right direction regarding any pitfalls or any other unwanted surprises and any documentation on the subject.
Will moving the database to a dedicated server improve performance?
Any assistance would be appreciated
