add-circle-bold add-circle add-square add alarm-bell-1 alert-diamond analytics-pie-2 archive archive arrow-down-1 arrow-down-2 arrow-left-1 arrow-right-1 arrow-up-1 attachment-1 bin-paper-1 book-star button-record check-1 check-circle-1 close close-quote close cog-1 cog common-file-stack copy-paste credit-card-1 diagram-fall-down disable time-clock-midnight download-thick-bottom drawer-send envelope-letter envelope-letter expand-6 expand-6 file-code filter-1 floppy-disk flying-insect-honey folder-file-1 headphones-customer-support hierarchy-9 hyperlink-2 information-circle keyboard-arrow-down keyboard-arrow-up layout-module-1 list-bullets lock-2 lock-unlock-1 love-it messages-bubble-square move-to-top multiple-circle multiple-neutral-1 multiple-users-1 navigation-menu-horizontal navigation-menu network-browser open-quote pencil-1 pencil-write pencil-1 print-text rating-star rating-star remove-circle remove-square-1 search send-email-1 shield-warning single-neutral-actions single-neutral smiley-sad-1 smiley-unhappy smiley-indifferent smiley-smile-1_1 smiley-happy smiley-sad-1 smiley-unhappy smiley-indifferent smiley-happy smiley-thrilled social-media-twitter synchronize-arrows-1 tags-double ticket-1 ticket-1 time-clock-circle undo view-1 view-off view wench

Resolving SQL Snapshot Error with EventID 24581


The SQL databases plan type ends with an error. The plan log indicates an error creating a VSS snapshot with the SQL writer.

ERROR: SQL snapshot was not created, there was nothing to backup for the db specified. 

In addition, the server running the plan logs event 24581.

Source : SQLWriter 
EventID : 24581 
"Sqllib error: System table sys.sysdatabases in SQL Server instance <Server\Instance> is empty."

Issue and Resolution

The SYSTEM account may not have permission to access databases. To resolve the issue, add the sysadmin role to the SYSTEM account. 

  • On the SQL server, open a command prompt as administrator. Type each line below.

use master
sp_addsrvrolemember 'NT AUTHORITY\SYSTEM','sysadmin'

  • Type services.msc and hit enter. In the services console, find and restart the SQL Server service and the SQL Writer service.