Attaching this database requires upgrade


Recently I was onsite with a client trying to recover their WSS 3.0 environment that they completely lost (post coming on that later).  During the recovery process I needed to add a content database back to their installation but received the following error in central administration:  Attaching this database requires upgrade, which could time out the browser session. You must use the STSADM command 'addcontentdb' to attach this database.

Apparently the backup that I had re-attached to SQL Server Express had a connection pool still attached to it.  Microsoft's work around is to add the content database via Stsadm.exe, and then restarting SQL Server services.

stsadm.exe -o addcontentdb -url URL -databasename DatabaseName [-databaseserver DatabaseServerName]

[-databaseuser UserName] [-databasepassword Password] [-sitewarning SiteWarning] [-sitemax SiteMaxCount]

Refer to this Knowledge Base: 926961 for more information.

Error message when you use SharePoint 3.0 Central Administration to try to re-add a content database in Windows SharePoint Services 3.0


- Dan Lewis

Comments (0)

Skip to main content