Recently, we came across a need to migrate an existing (SharePoint 2007) RTM content database to a new farm, which had SP1 pre-installed. After taking a full backup of the existing database (through SQL Server), the backup was restored in the new farm.
Note: I should also mention that the database was migrating from SQL Server 2000 to SQL Server 2005.
After resetting the SharePoint servers, browsing to the site in question brought the following error:
Server error: http://go.microsoft.com/fwlink?LinkID=96177
At this point, we detached the content database in question (Central Administration » Application Management » Content databases). Once the database was successfully detached from the farm, it was reattached using the following STSADM command:
stsadm -o addcontentdb -url ‹URL› -databasename ‹DBNAME›
Reattaching the content database with the above command completely successfully, and as an added benefit performed an inplace upgrade, bringing the database schema up to SP1. This might prove to be a helping hand when it comes to migrating to MOSS 2007 SP1 if your wish is to start with a new farm, but retain your original content.
Hello, I tried the process described, but didn’t work for me. My environment is almost the same you describe (I did not migrated the SQL versions, they’re both the same SQL05)
I first planned for what’s suggested on Technet site, Migrate databases … so I did, and I started getting error messages Event ID 5617 (Topology)
”
The schema version (3.0.149.0) of the database WSS_Content DATABASE_SERVER is not consistent with the expected database schema version (3.1.3.0) on WEBFRONT. Connections to this database from this server have been blocked to avoid data loss. Upgrade the web front end or the content database to ensure that these versions match.”
I tried
stsadm -o upgrade -force
psconfig –cmd upgrade –inplace v2v –force -wait
with no successfull results
Then I tried using a new updated empty WSS_Content and restore separately each of my sites. Did not work
I performed your suggestion for GUIdetaching/STSADMattaching, with no success neither
most confusing yet is I tryed later on a lab environment in the same sharepoint version, and there’s no difference for the results.
Maybe at this point, I’m already frustated enough so I’m not seeing the right path to solution.
Any guidance/tip/help is more than welcome
regards,
R.