About Me

My photo
TsooRad is a blog for John Weber. John is a Skype for Business MVP (2015-2018) - before that, a Lync Server MVP (2010-2014). My day job is titled "Technical Lead, MS UC" - I work with an awesome group of people at CDW, LLC. I’ve been at this gig in one fashion or another since 1988 - starting with desktops (remember Z-248’s?) and now I am in Portland, Oregon. I focus on collaboration and infrastructure. This means Exchange of all flavors, Skype, LCS/OCS/Lync, Windows, business process, and learning new stuff. I have a variety of interests - some of which may rear their ugly head in this forum. I have a variety of certifications dating back to Novell CNE and working up through the Microsoft MCP stack to MCITP multiple times. FWIW, I am on my third career - ex-USMC, retired US Army. I have a fancy MBA. One of these days, I intend to start teaching. The opinions expressed on this blog are mine and mine alone.

2009/11/17

SharePoint stuck in Read-Only

Our office, like many others, uses SharePoint for a wide variety of uses.  To say that our SharePoint is “business critical” is not an over-statement.  Recently, we ran our SQL Express instance of the SharePoint database into the SQL Express 4GB database size limit.  While moving the database was not a huge issue, what was an issue is that SharePoint, on an internal basis, apparently marked the database as “read-only.”

What is important here is that SQL did not think the database was locked, SharePoint thought it was locked.  After we moved the database to full SQL server, and reconnected the database to the SharePoint farm server, we still could not edit, add, or remove items, documents, or perform other action/task except look at database contents.

Running the following command showed that SharePoint had the database marked as “readonly” (command may have wrapped)

stsadm -o getsitelock -url http://servername

This command returned this output, which explained our issue!

<SiteLock Lock="readonly" />

How to fix this?  Here’s how: (command may have wrapped)

stsadm -o setsitelock -url http://servername -lock  none

Problem solved!

1 comment:

JhonKa said...

THANK YOU. This worked perfect and saved me from going insane!

What Vacation Taught me

I took vacation this year; a formal thing with travel, schedule coordination, planned activities, and days full of interacting with others. ...