Failed to enumerate Microsoft SQL Server databases:

#21

VSS is the Windows integrated solution to take snalshots of a volume and backup open files.
Did you try to add the --snapshot-policy=off option, as suggested in issue 3752?

#22

ohh wow at this cool thing, but how to turn it on.
And then I had to add filters when copying --include = [] open files that were occupied by the process, this is not very convenient.

I made the setting off did not help the error persisted.

#23

@kees-z
@mnaiman
who has any thoughts? what to do

#24

And how HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server looks like?

#25

Volume shadow service. You SQL installation is probably broken.
Do you have Microsoft SQL Server VSS Writer in Add/Remove programs installed?
Try to repair your SQL installation.

#26

Run “vssadmin list writers” and show results

#27

And search windows event log about VSS or SQL warning/errors.

#28

my log

VSSADMIN 1.1 - Volume Shadow Copy Utility
(C) Microsoft Corporation, 2001-2005.

Waiting for answers.
There may be delays if the shadow copy is in preparation.

Write component name: "Task Scheduler Writer"
   Record Component Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}
   Record component instance id: {1bddd48e-5052-49db-9b07-b96f96727e6b}
   Condition: [1] Stable
   Last Error: No Error

Record Component Name: "VSS Metadata Store Writer"
   Record Component Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}
   Record Component Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}
   Condition: [1] Stable
   Last Error: No Error

Record Component Name: "Performance Counters Writer"
   Record Component Id: {0bada1de-01a9-4625-8278-69e735f39dd2}
   Record component instance id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}
   Condition: [1] Stable
   Last Error: No Error

Write component name: "System Writer"
   Record Component Id: {e8132975-6f93-4464-a53e-1050253ae220}
   Record Component Instance Id: {48023764-a609-4156-b4ff-7035ed7ff288}
   Condition: [1] Stable
   Last Error: No Error

Writing component name: "ASR Writer"
   Record Component Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
   Record component instance id: {109ca996-33d3-40e1-a034-117a42504625}
   Condition: [1] Stable
   Last Error: No Error

Record Component Name: "Shadow Copy Optimization Writer"
   Record Component Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}
   Record Component Instance Id: {e917fcd7-042b-4ef1-b082-531dcaa974df}
   Condition: [1] Stable
   Last Error: No Error

Writing component name: "WMI Writer"
   Record Component Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
   Record component instance Id: {c92cb95d-906e-4ada-8766-60a0f35db9b4}
   Condition: [1] Stable
   Last Error: No Error

Writing component name: "BITS Writer"
   Record Component Id: {4969d978-be47-48b0-b100-f328f07ac1e0}
   Record Component Instance Id: {5e0adc9a-c47d-4892-80da-aec2af6f0de4}
   Condition: [1] Stable
   Last Error: No Error

Record Component Name: "Registry Writer"
   Record Component Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
   Record component instance id: {63c0989a-670d-47e0-b9b3-2d110646db67}
   Condition: [1] Stable
   Last Error: No Error

Record Component Name: "COM + REGDB Writer"
   Record Component Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
   Record component instance id: {64f1db18-9ac6-4aae-b474-0ace88227b8f}
   Condition: [1] Stable
   Last Error: No Error

Windows error event

Volume Shadow Copy Error: An unexpected error occurred when calling the CoCreateInstance routine. Hr = 0x80070422. The specified service cannot be started because it is disabled or all devices associated with it are disabled.
.

Operation:
    Creating an instance of a VSS server
Volume Shadow Copy Information: Cannot start a COM server with CLSID {e579ab5f-1cc4-44b4-bed9-de0991ff0623} named IVssCoordinatorEx2. [0x80070422, The specified service cannot be started because it is disabled or all devices associated with it are disabled.
]

Operation:
    Creating an instance of a VSS server

VSS is shutting down due to idle timeout.


#29

I do not have such an entry in the registry

#30

Check it without the “Wow6432Node” part.

#31

here found an entry in the registry

#32

So yeah, you have a 64-bit version of SQL Express installed.

Maybe the error is due to the VSS writer for MS SQL being missing (not sure).
If you are certain you don’t need SQL Express, you could potentially uninstall it.

#33

I plan to work with MS SQL and which module should I install?
What stages do I need to do to make it work dupliciti + VSS + MS SQL (x32 and x64)
You can even link to the installation packages required

#34

Try googling “sql vss writer is missing” - I did and see several hits. Maybe that is the root cause of your issue - if you can resolve it the problem will go away (hopefully!)