We have been experiencing reoccuring problems with two databases (DBs) being marked as suspect after restarting SQL.
One of the DBs is the msdb. It is constantly being marked suspect after a SQL Server service restart (or reboot of the server). the other is a workflow DB.
It appears the problem starts upon initialization of the MS DTC. The message returned is ‘Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE’.
Since the MS DTC uses the MTS to handle transactions, Ibelieve that part of our problem may lie in this error.
There is also an error that occurs during the disk initialization phase of SQL. The error reported is OS system error 5:Access Denied.
We have used the dbhelp option to determine the DB owner; it is ‘sa’. We have checked the device file permissions. They are set to ‘Everyone’ and ‘Full Control’. Furthermore, all other DBs – there are a total of 12 including the system DBs – start
without a problem. There is one exception. The DB which handles document workflow is experiencing the same problems as the msdb.
I have researched some of this on the Microsoft web site, but found very limited information (big surprise 😐 ).
The last error message recorded during the recovery of the DB is OS error 6: The handle is invalid. This message displays a virtual page address in hex.
The only other strange thing that is happening is related to the MS DTC log file being set to read-only. No record of how this is happening.
Weare running NT 4.0 with SP 5, SQL 6.5 with SP 5a on a Dual Intel PIII processor system with 512 MB of RAM.
Any input will be duely rewarded! Thanks!
