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
Women in Life Sciences ESG
Webinar
Join us for a blooming ESG discussion and a floral arrangement workshop!

July 20, 2022 | 03:00 PM - 05:00 PM PT
Unleash Your Nonprofit’s Fundraising Cloud Strategy
Webinar
Realizing you need to replace outdated and siloed technology is step one.

July 19, 2022 | 01:00 PM - 01:30 PM PT
Why SaaS Metrics Matter Webinar Thumbnail
Webinar
Discover how collecting and reporting the right SaaS metrics can help analyze the health of your organization.

July 19, 2022 | 10:00 AM - 11:00 AM PT