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.
- Dan Lewis