Armanino Blog
Article

Moving SQL to a new server

August 14, 2008

Just moved MSDE 2000 to a new server with MSDE 2005. Well worth the update as MSDE 2005 is a free download as well and is way better than the admin consol. Other than not having a backup agent MSDE 2005 looks and feels very much like good old SQL 2005.

Here is the link to get to MSDE 2005 express: https://www.microsoft.com/express/2005/sql/default.aspx

Here's an article to set up a backup routine for MSDE: http://www.sqldbatips.com/showarticle.asp?ID=27

Process I did to move to a new server:

  1. Make backup of DYNAMICS and company databases
  2. Run capture login scripts found at: https://mbs.microsoft.com/fileexchange/?fileID=879594a6-60ee-421f-b6ab-4d77da3aba22
  3. Install MSDE on new server (Mixed mode)
  4. Install GP on new server
  5. Copy output from #2 and run on new server (will automatically run against master database)
  6. Restore DYNAMICS database and company database to new server (All tasks>>restore>>type in database name exactly as it was on previous server)
  7. Change ODBC connections on workstations to point to new server
  8. Update Dynamics.set file on all workstations to point to new shared directory with new reports.dic file location

Process could also be used for regular SQL installs.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
IPO Prep & SOX Compliance: Instacart & Armanino Share Hard-Earned Knowledge
Webinar
Know your compliance requirements today to avoid obstacles tomorrow.

December 16, 2021 | 11:00 AM - 12:00 PM PT
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Why COP26 Matters for Your Business Webinar
Webinar
Get informed of COP26 developments and how you can act now.

December 15, 2021 | 10:30 AM - 11:00 AM PT