The Yosemite Server Backup Agent for Microsoft SQL Server supports the following SQL Editions:
- SQL Server 2014
- SQL Server 2012 Service Pack 1
- SQL Server 2008 R2
- SQL Server 2005 Service Packs 1, 2, 3, 4
Some editions of Yosemite Server Backup do not provide a license to backup Microsoft SQL data. By default, an evaluation version of the Yosemite Server Backup agent is installed automatically when you install Yosemite Server Backup on each Windows server. You can use this evaluation license for 60 days. To continue using the agent, contact your sales representative to purchase an edition of Yosemite Server Backup that supports Application agents.
Microsoft SQL Server environments are frequently mission-critical and must be maintained 24 hours a day, seven days a week. Procedures and plans must be in place to ensure the quick recovery of data in the event of data loss.
Using the transaction logs associated with each database, you can quickly recover your databases. Transactions that were not committed can be rolled back, while transactions that were committed can be written to disk.
While transaction logs assure that only committed transactions are written and restored, in order to use them correctly, you must have a comprehensive backup plan that regularly backs up these logs. Additionally, when you reconstruct a database, you must restore the database files and logs using only the procedures set out in this section.
This section contains important information pertaining to Microsoft SQL Server database instance backup and restore.