We are working on a SharePoint 2007 installation and attempting to upgrade it to SP2. The upgrade is failing with the following error: Exception: System.Data.SqlClient.SqlException: Could not continue scan with NOLOCK due to data movement
The consultant with whom I am working thinks this is a SQL Server error related to space issues on the Admin Content database.
When I look at sp_spaceused for this database I see the following:
size: 58 MB
Unallocated: 3.23 MB
reserved: 55696 KB
data: 43944 KB
index_size: 10504 KB
unused: 1248 KB
Since I don't know anything about space and how it is allocated and used in SQL Server, I wanted to know if this database has sufficient space, and if not, how would I go about giving it more space? Are we even on the right track?
Any suggestions or thoughts would be appreciated.