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]
gouse BrokenDB
go
sp_changedbowner ‘Domain\NewUserAccount‘
gosp_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
« Show users that have access to mailboxes on Exchange 2007/2010 Restore Virtual machine when an aVHD is used »