May 24, 2010 at 11:55 pm
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.
Regards,
Perla
May 25, 2010 at 1:44 am
What errors are there in the SQL error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply