locked
Unable to add restored content db to a web application in a different server RRS feed

  • Question

  • We are facing an issue while adding a restored content db from a different server to a  web application in SP 2007.

    We are getting an error "Restore on mb-sptest02 contains user-defined schema.  Databases must be empty before they can be used.  Delete all of the tables, stored procedures and other objects or use a different database.  " while running the stsadm command-

    stsadm -o addcontentdb -url siteurl -databasename dbname -databaseserver servername

    We checked for versions and found both servers has the same version.

    Does any one know the solution to this problem

    Thanks in advance

    Tuesday, September 10, 2013 8:17 AM

Answers

  • Will this help you ?

    But in your case, you might have to run this on your source environment and get the backup again.

    psconfig –cmd upgrade –inplace b2b –wait –force

    "It appears someone installed a SharePoint patch into the environment but never ran the configuration wizard. So although SharePoint was operating correctly, when re-attaching the database is knew something was run."

    Ref -

    http://paulliebrand.com/2013/03/28/database-on-server-contains-user-defined-schema-databases-must-be-empty-before-they-can-be-used/



    Tuesday, September 10, 2013 8:22 AM