I came across this problem late last night. I needed to change the recovery model of a SharePoint DB, but came up with this error

After a bit of searching i managed to find out how to fix it.

The problem is caused by a deleted account in AD that was the owner of the DB, so this needs to be changed to a REAL account.

Open SQL Manger

Right click a DB, then select “New Query”

CREATE LOGIN [Domain\NewUserAccount] FROM WINDOWS WITH DEFAULT_DATABASE=[BrokenDB]
go

use BrokenDB
go
sp_changedbowner ‘Domain\NewUserAccount‘
go

sp_helpdb

Right click, “Execute”

This should then run through and change the owner of the DB as requires.

Then look at the Results tab down the bottom, and you should see the new owner listed

« »