SQL Writer Error – ‘sysdatabases in SQL server instance is empty.’


You might have noticed an error in the application log for some server with in your environment which says sysdatabases in SQL server instance <Instance Name> is empty.

Cause

 

This is a SQLWriter error when we have a VSS based backup solution implemented.The backup solution is using SQL Server VSS Writer Service to connect to SQL and this account doesn’t have sysadmin rights or not part of logins.In most of the cases SQL Server VSS Writer Service will be running on Local System account.

Solution to clear the error message

 

We have to add back NT AUTHORITY\SYSTEM if it was removed and grant sysadmin rights incase Writer Service is using Local System account.

I am curious to understand if any one of you are facing this issue.

Advertisements

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