Hi,
Was wondering Will Server Essentials 2016 built in backup backup sql open database files and include them in the backup image?
Think our work software runs of an sql anywhere backend.
Thank you
I am not a SQL tech so probably best answered by your database vendor but according to SAP documentation when using a SQL Anywhere database:
Reference: http://dcx.sap.com/sqla170/en/html/3bc7eaa06c5f1014acf58703190ea349.html
SQL Anywhere Volume Shadow Copy Service (VSS) SQL Anywhere is compatible with the Microsoft Volume Shadow Copy Service (VSS).
By default, all SQL Anywhere databases can use the VSS service for backups if the SQL Anywhere VSS writer (dbvss17.exe) is running. You can use VSS without the SQL Anywhere VSS writer to back up databases. However, you might need to use the full SQL Anywhere recovery procedures to restore those databases.
To prevent a database server from participating in the VSS service, include -vss- when starting the database server. You can also control when the VSS service is running using the Service utility (dbsvc) for Windows.
How VSS works with SQL Anywhere:
1. Your backup application sends a command to VSS to take a snapshot.
2. VSS issues an identify command to the SQL Anywhere VSS writer (dbvss17.exe).
3. VSS issues a prepare to snapshot command to suspend all transactions and write all modified pages to disk on all databases on all database servers. If transactions are not suspended on a database within 10 seconds, the snapshot might contain uncommitted transactions and full recovery may be necessary.
4. VSS issues a freeze command to checkpoint and then suspend all activity on all databases on all database servers. Each SQL Anywhere database server waits a maximum of 60 seconds for all databases to suspend all activity. Typically, this process takes a few seconds.
5. VSS issues a thaw command to the SQL Anywhere VSS writer to resume all transactions on all databases on all database servers.
Even if you use the VSS service, consider using a backup strategy that involves full backups and periodic incremental backups. In rare circumstances, SQL Anywhere might be unable to suspend transactions or complete a checkpoint within the maximum time allowed by VSS. If this situation occurs, and you have been performing SQL Anywhere backups, use the transaction log file and the full recovery process to recover your data.
Hope that helps,
EDITED: to fix terrible formatting :(