Here’s a quick tip from the Head GEEK to help you backup MS SQL Server databases using CDP Enterprise Edition.
R1Soft CDP Enterprise Edition for Windows uses MS Volume Shadow Copy Service (VSS) to protect your Windows server and applications like MS SQL Server databases.
1. When protecting MS SQL Server with CDP Enterprise Edition make sure the “SQL Writer Service” is Enabled! This service must be running when CDP Enterprise Windows Agent requests a backup using Volume Shadow Copy Service (VSS). The VSS Writer allows the Windows CDP Agent to make a stable asynchronous replica of your running MS SQL Server databases.
2. You can restore individual MS SQL Server databases while SQL Server is running with two easy steps.
To restore a MS SQL Server database:
• Restore the database data and log files using CDP Enterprise Edition file restore
• Attach the restored data and log files to SQL Server using SQL Server Management Studio
Documentation for this tip including step-by-step screenshots is here.