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

Resolving SQL Snapshot Error with EventID 24581

Behavior

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
go
sp_addsrvrolemember 'NT AUTHORITY\SYSTEM','sysadmin'
go
exit

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