SharePoint Dev Center >
> 
> 
How to import a .BAK file in Sharepoint 2010 ?

Answered How to import a .BAK file in Sharepoint 2010 ?

  • Tuesday, May 08, 2012 1:28 AM
     
     
    Sign In to Vote
    0

    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:

    Go back to site
    ErrorError
    This 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.

     
    • Moved by Lhan HanModerator Tuesday, May 08, 2012 1:34 AM sp2010 (From:SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010))
    • Edited by Sherman868 Stewart Tuesday, May 08, 2012 1:37 AM
    •  
     

All Replies

  • Tuesday, May 08, 2012 1:47 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    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.

    http://sharepoint.nauplius.net

     
  • Tuesday, May 08, 2012 6:27 PM
     
     
    Sign In to Vote
    0

    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.

    Thanks

     
  • Wednesday, May 09, 2012 7:52 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Sherman868,

    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:
    http://technet.microsoft.com/en-us/library/cc263422(v=office.12).aspx

    More information about upgrading to SharePoint through database attach:
    http://technet.microsoft.com/en-us/library/cc263299.aspx
    http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/aba647cf-b502-480a-ba4c-3a46cbbf7d54

    Thanks,
    Qiao

    Qiao Wei

    TechNet Community Support

     
  • Thursday, May 17, 2012 5:45 PM
     
     
    Sign In to Vote
    0

    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

    Regards,

    Sherman