[SOLVED] :MS SQL Server 2008 R2 Error Log Growing in huge size

On SharePoint Database server SQL error log file was getting increased in huge size in 2 day 5 GB and below message was getting recorded in it continuously

SPID 24s ” An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. ”

So get the details which process is getting error followed below steps

  1. Opened new Query Window
  2. SP_who2 and searched for SPID 24
  3. It was spid 24   status: background    loginname: sa    cmd: BRKR Task
  4. Now select * from Sys.sysdatabases to get the list of all databases
  5. Copied all databases names in Excel file and created below commands
  6. Use <Databasename > ( for all databases )
  7. Go
  8. sp_changedbowner ‘SA’
  9. same for all Databases ( list copied from step 5)
  10. executed in bunch
  11. Restarted SQL server service.

That’s all , it has resolved the error logging issue and Log file stopped growing with the error meesages J

Thanks

 

Prashant Deshpande


 

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s