Agent for SQL

Single-pass backup of Microsoft SQL Server data becomes available by using Acronis Backup Agent for SQL.

Backup

During a disk backup, Agent for SQL adds Microsoft SQL Server metadata to the resulting backup file. By using this metadata, Acronis Backup detects and catalogues SQL Server databases. After the backup is successfully completed, the agent truncates the SQL Server transaction log if the corresponding option in the backup plan has been set.

Recovery

The agent enables you to recover SQL databases directly to a running SQL Server instance. You can make a database available to users immediately, or perform additional operations before making it available.

The agent can also extract database files from a single-pass backup to a folder on a file system. These files can be used for data mining or auditing. In case of emergency, you can attach these database files to a SQL Server instance that is not managed by the agent.

Mounting databases

By using the agent, you can temporarily attach a backed-up database to a running SQL Server instance and use third-party tools to get various objects from this database.