• not that I can tell as there is a DDL trigger which fires for all ddl events using the root DDL_EVENTS but unsure if restore /attach/detach come under the DDL_SERVER_LEVEL_EVENTS category so might not have logged it, the create date on the DB is back in Feb 2011.

    msdb.dbo.restorehistory shows the last restore was in Feb for a staging DB so nothing which affects the database

    What I have got from the DDL trigger is this which happened at 9:45, so around 30 minutes after the initial error, which from what I have read on google, is the guys here trying to fix the issue

    ALTER DATABASE database SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    ALTER DATABASE database SET ENABLE_BROKER;

    ALTER DATABASE database SET MULTI_USER

    ALTER AUTHORIZATION ON DATABASE::[database] TO [SA];

    ALTER AUTHORIZATION ON DATABASE::[database] TO ;

    ALTER AUTHORIZATION ON DATABASE::[database] TO [sa];

    EXEC master..sp_addsrvrolemember @loginame = N'user', @rolename = N'sysadmin'