Tuesday, May 08, 2012 1:28 AM
Hi to all
Problem:- I want to deploy a Sharepoint solution within the company I work for. But I was handed a .BAK file which is a backup of the company's database. I was able to import the datatbase into SQL server but when I tried to add a second database to sharepoint was stopped by this error.
Error Mesage:ErrorThis content database requires upgrade and could not be attached in this operation. Use either the [stsadm -o addcontentdb] command or [Mount-SPContentDatabase] cmdlet instead.
Your assistance with this would be greatly appreciated.
Tuesday, May 08, 2012 1:47 AMModerator
Do exactly what the message says. Run:
Mount-SPContentDatabase <databasename> -WebApplication http://sharepoint
Do this with a user that has securityadmin or sysadmin on the SQL Server, along with Farm Admin/Local Admin on the SharePoint farm.
Tuesday, May 08, 2012 6:27 PM
I did exactly what the message said but I was stopped by an error which stated: Mount-SPcontentdatabase : Invalid object name 'sites'. I want to basically view the information in that database via sharepoint I saw an error that said I should upgrade the database first.
Can you give me some direction on this.
Wednesday, May 09, 2012 7:52 AMModerator
Do you mean that you met this error message when you attach the database to SharePoint through “add a content database”?
What happened when adding the database using command: stsadm –o addcontentdb –url http://siteurl –databasename databasename? more information about this, see:
More information about upgrading to SharePoint through database attach:
TechNet Community Support
Thursday, May 17, 2012 5:45 PM
My deepest apologies for my late response I have been out of the country for a little while. I am so grateful for the replies I am going to try all the suggestions and let everyone know. Thanks so much