database is not empty and does not match current database schema

Question

_{Tuesday, September 29, 2015 1:03 PM}

Hi,

Farm structure-- 2 web servers and 2 app servers

We are getting this error for a few content databases

"Database 'xxxxx' on SQL Server instance 'xxxxxx' is not empty and does not match current database schema" by the farm account, excel account some users accounts etc

Please suggest what can be done in this regard. All the sites in those content dbs are working and functional.

But this issue is there for 3 servers in the farm out of 4 ( not present in one web server).

All replies (5)

_{Tuesday, September 29, 2015 1:57 PM}

Hi sp- did you check out the following links? It's probably due to the fact that your servers don't have the same updates installed.

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/e2aff4d0-e72b-4f29-ba62-6335919f2959/database-sharepointadmincontent-on-sql-server-instance-sql-server-is-not-empty-and-does-not?forum=sharepointadmin

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/24e2bfc7-cf71-4548-bde3-5720b7a24bbb/how-to-resolve-this-error-database-on-sql-server-instance-is-not-empty-and-does-not-match-current?forum=sharepointadminprevious

cameron rautmann

_{Tuesday, September 29, 2015 3:23 PM}

These links are not relevant in this case. 1st link is about distributed cache which is in SP 2013 and our version is SP 2010. 2nd link about having security admin permission which is not possible for all the accounts to have.

_{Tuesday, September 29, 2015 3:30 PM}

I think you should take a closer look at the content as you are missing the main points in the links. Forget the part about distributed cache in the first link and the second link isn't suggesting everyone have admin permission.

cameron rautmann

_{Tuesday, September 29, 2015 3:48 PM}

I think it also says about product version in all the servers in the farm. I checked all the servers are in the same patch level.

_{Wednesday, September 30, 2015 6:53 AM}

Any further idea?