"Internal query processor error: The query processor encountered an unexpected error during execution. Change database context to 'msdb'" error message showing while trying to take POS backup.
- Aparajita Basu Roy
SYMPTOMS
An error occurred while trying to take POS backup. The following messages appear on Screen.
Internal query processor error: The query processor encountered an unexpected error during execution.
Change database context to 'msdb'.
Attempt to fetch logical page(1-289) in database 4 failed. It belongs to allocation unit 72057594045005824 not to 72057594045267968.
Changed database context to 'msdb'.
Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery. See the SQL serve errorlog for more information.
CAUSE
Due to abnormal shutdown SQL server system database (MSDB) got corrupted.
RESOLUTION
Open MasterDBTools.exe tool from GINESYS POS installation folder.
After that click on Stop button to stop the SQL server (If its in running state).
Then select the SQL server instance ( Example : MSSQLSERVER or SQLEXPRESS ) & Put password in the password filed for "sa" account.
Then click on MSDB checkbox and click on "Copy from Template".
Finally, click on "start" button to start the SQL server service & check.
MSDB is responsible for Backup related tasks of SQL server databases, hence it needs to be repaired.
Open event viewer to check the log details about abnormal shutdown status, Disk Error, NTFS Error, same should be informed to client.
Check the log details about SQL server error or MSDB corruption, details should be informed to client.
After replacing the MSDB file using MasterDBTools.exe tool if the same issue still persists then inform client to re-installation SQL server post taking proper Data backup.
This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/
RELATED ARTICLES
Mention any related articles here.