BackupVault Pro automatically detects a running MS SQL service and displays a SQL tab option on the left hand side. Occasionally the box will not be displayed and this is typically due to the permissions set within Microsoft SQL itself.
Note: After each section, open the BackupVault ESE client to see if the SQL tab has appeared on the left hand side.
To fix, follow these steps:
Check if the SQL server role has the correct permissions
- Open the Microsoft SQL Management Studio and login as an authorised user
- Expand the Security then Logins folders
- Right-click on the NT AUTHORITY\SYSTEM user and select Properties
- Select Server Roles and tick the Sysadmin option
- Click Ok
If there are errors in the logs relating to the SQL writer, or if the SQL tab itself is not appearing, go through this checklist of common fixes:
Note: After each check, open the BackupVault ESE client to see if the SQL tab has appeared on the left hand side.
Check if the ‘SQL VSS writer’ is running
- Open Command Prompt as administrator
- Type: vssadmin list writers
- Check the state of the listed writers. They should be all reading:
State:  Stable
Last error: No error
If the writer is displaying errors or is not present, then the associated service will need restarting.
Check the required services are present / running in services.msc
- From the start menu, search for “Run”
- Enter “services.msc”, hit enter.
- Confirm the “Volume Shadow Copy” service is present.
- Confirm the “BackupVault ESE” service is present and running.
Try to launch the ‘SQL Server VSS writer’ service under .\Administrator (local administrator) account
- Go to services.msc console and select SQL Server VSS writer service;
- Select Properties > Log-On tab and specify Administrator account credentials;
- Once done, restart below services from services.msc
- Cryptographic Services
- Volume Shadow Copy
- Microsoft Software Shadow Copy Provider
- SQL Server VSS writer
- Restart the BackupVault ESE service from services.msc
Check the SQL tab is present in the BackupVault client
- Open the BackupVault ESE client to view the SQL tab on the left hand side
- Right click on the database you wish to backup and select Include