Sharepoint 2007 and attaching content database with SQL 2012 R2

Today I had to migrate an old wss 3.0 site to Sql 2012 R2.

Made backup of the old DB and transfered it to the new server. Then restored it and tried.

STSADM –o addcontentdb –url http://ssps001:7242 -databasename _wss_content_old -databaseserver SDBA001

But if failed and upgrade.log at (C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12LOGS) stated:

[ERROR] [12/22/2013 8:33:39 PM]: Upgrade [SPContentDatabase Name=WSS_CONTENT_OLD
Parent=SPDatabaseServiceInstance] failed.
[SPManager] [ERROR] [12/22/2013 8:33:39 PM]: Invalid object
name ‘dbo.trace_xe_action_map’.

So with a little bit of searching I found that out I have to create a synonym in the context to the database:

CREATE SYNONYM [dbo].[trace_xe_action_map]
FOR [sys].[trace_xe_action_map];
CREATE SYNONYM [dbo].[trace_xe_event_map]
FOR [sys].[trace_xe_event_map];
And after this it worked and database got attached succesfully.
Author: Harri Jaakkonen

Leave a Reply

Your email address will not be published. Required fields are marked *