Troubleshooting MS SQL backups
In most cases uncompleted backup sessions are restarted automatically. However, if an error persists, you can try these steps for troubleshooting:
- Make sure the required shadow copy services are running (SQL Writer Service and Volume Shadow Copy). It can be done using the
vssadmin list writerscommand.
- Check for error messages in application event logs.
- Make sure there is enough free space in the VSS Shadow Copy storage area (otherwise the system can start deleting snapshots required for backups).
If none of the above helps, please contact support for assistance.