Home » Categories » Setup / IT information

Upgrading to SQL 2008 Express

Overview

Following are the steps to upgrade to SQL version on your Server. 

Detailed Instructions

Before You Begin - Requires TDO Backup

Prior to beginning it is REQUIRED that a backup be made of the TDO Server Data. This backup has to be run using the TDO Backup utility. No exceptions. Please make sure the backup completes without errors. If it completes with errors, please resolve that issue first as it will be necessary to use this backup in the process of upgrading SQL. If this is not done correctly, you will very likely lose data.

-Login to tdo4endo.com and in the Download TDO area, download the SQL2008Express.exe or the SQL2008Expressx64.exe installer and save it to your TDO Builds directory. (Please remove or archive any old installers for SQL from this folder)

-Ensure no one is using TDO and that TDO has been closed on all computers.

-Stop TDO Cloud Service (if using TDO Cloud Service).

-Stop TDOSQLSERVER process in Administrative > Services.

-Uninstall old version of SQL Server (likely MSDE or SQL Server 2005 Express).

-Open Windows Explorer to your TDOfficeData directory and clear out all files in the root of that directory leaving all folders intact.

-Run TDOProfessional installer selecting server as the installation type. This will install the newer version of SQL Server providing it is in the TDO Builds directory as previously directed.

-Upon completion, open TDO to verify the installation was successful. (The database will be blank).

-Close TDO.

-Launch the TDO Backup utility and ensure the backup path points to the directory containing the server data backup that was run.

-Ensuring that only Server Data is checked, click the Restore button.

-Follow any on screen prompts

-Check that the Restore completed without errors.

-Restart the TDO Cloud Service

-Launch TDO to verify that the SQL upgrade has completed successfully.

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Updating Carestream 3D software
Viewed 2944 times since Jul 24, 2015
Carestream 1200 and 1500 Intraoral Camera Setup
Viewed 1920 times since Nov 15, 2018
Microsoft SQL Size Limitations by Version
Viewed 726 times since May 23, 2018
TDO integration with CloudPBX software
Viewed 1558 times since Jan 20, 2018
Beta Tester Responsibilities
Viewed 493 times since Dec 4, 2018
Adding Dental Exchange information into TDO
Viewed 2447 times since Jun 8, 2015
How to Uninstall Microsoft Access 2002 Runtime
Viewed 2903 times since Jul 14, 2017