Getting below error while connect to SQL server 2005.
Could Not Continue Scan With NOLOCK Due To Data Movement(Microsoft Sql Server error:601)
I cross verified the database files on drives (we have C and D drives) ...system database files are missed(mdf and ldf) but only one user database files are appearing.
We received a request from appln team SMVI backup's failing,so we started the troubleshooting...found database files are missing.
Even SQL services are showing as running state from services.msc.
Can any one suggest how can we fix the issue and why this type of issues occurs.