Symptom
While restoring the PointCentral SQL Database from Microsoft SQL Server Managemenet Studio, an error occurs:
"Restore failed for Server 'Servername'. (Microsoft.SqlServer.Express.Smo). Additional Information: System.Data.SqlClient.SqlError. Exclusive access could not be obtained because the database is in use..."
Cause
You did not properly stop all PointCentral applications before restoring the PointCentral SQL Database.
Solution
Stop PointCentral applications during the restore process
- From the PointCentral server, go toStart > Run.
- In the Open field, enter cmd, and then click OK.
- From the Command Prompt, enter iisreset /stop. This stops PointCentral admin and service.
- From the Command Prompt, enter net stop CalyxPDSFileSync. This stops PointCentral FileSync.
- You may continue with restoring the PointCentral SQL Database.
Start PointCentral applications
When you have completed the PointCentral backup process, you must restart the PointCentral applications for users to be able to access Point data.
- From the PointCentral server, click Start > Run.
- In the Open field, enter cmd, and then click OK.
- From the Command Prompt, enter net start CalyxPdsFileSync and then press <Enter>.
- From the Command Prompt, enter iisreset /start, and then press <Enter>.
- Exit the command prompt.
The users can now log back into Point and access their loan files.