...
Problem (Issue) Statement: | How to replace xPortalNet database with database data files (MDF and LDF file types) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description: | A guide to restore xPortalNet database using database data files (MDF and LDF file types) to new Server's PC. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Related Software: |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Related Hardware: | NA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
System Application: | xPortalNet Standard Software | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Symptom and Finding: | After copying and replacing existing physical database data to new Server PC using MDF and LDF file types at C: ProgramData\MicroEngine\xPortalNetv1 folder; when xPortalNet Server is launched, software prompted "Error Adding Transaction" message. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cause: | The steps to replace existing physical database to new Server PC are done incorrectly, without properly detaching fresh database (empty) from SQL Server and attaching existing database (old database) to SQL. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Solution: |
. . Summary
Step by Step:
.
.
Step 1: Ensure that xPortalNet Service, Server and Client are not running. Stop xPortalNet Service if the service is still running. Close all software instances if any of the software instances are still running.
.
Step 1: After pasting the copied xPortalNet database data, users have to re-attach the existing database to SQL Server.
.
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Date Documentation: | 9/4/2018 (Rev 1.0) |
...
Section | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
|
.
...
.
Choices for confluence | ||
---|---|---|
|