Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Microsoft Sql Server error:601 Expand / Collapse
Author
Message
Posted Monday, May 24, 2010 11:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 10, 2011 12:50 AM
Points: 4, Visits: 43
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
Post #927207
Posted Tuesday, May 25, 2010 1:43 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 41,517, Visits: 34,432
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic927206-146-1.aspx


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #927251
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse