Wednesday, May 07, 2008 4:21 PM
danlewisnet
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
Filed under: SharePoint, WSS