In this case, Veeam periodically will transfer transaction logs to the backup repository and store them with the SQL server VM backup, truncating logs on the original VM. This option supports any database restore operation offered through Veeam Backup & Replication. The options available are truncate logs, do not truncate logs, or backup logs periodically.įigure 1: SQL Server Transaction logs Optionsįigure 1 shows the Backup logs periodically option is selected in this scenario. Veeam has different options available to help process the transaction logs. This technology creates a transactionally consistent backup of a running VM minimizing the potential for data loss.Įnabling Application Aware processing is just the first step, you must also consider how you want to handle the transaction logs. This is done so there are no unfinished database transactions when a backup is performed. This technology quiescences the applications running on the virtual machine to create a consistent view of data. Application aware processing is Veeam’s proprietary technology based on Microsoft Volume Shadow Copy Service. An important aspect and easy way to ensure your backup is consistent is to check that application-aware processing is enabled for the backup job. There are some things you should take note of when using Veeam to back up your Microsoft SQL Server. This blog post aims to discuss using these tools and what Veeam can offer to help ensure your SQL Server databases are well protected and always available to your business. Veeam’s intuitive tool, Veeam Explorer for Microsoft SQL Server, is easy to use and doesn’t require you to be a database expert to quickly restore the database. Veeam specifically has tools to back up your SQL Server and restore it when needed.
Microsoft SQL Server works on the backend of your critical applications, making it imperative to have a strategy set in place in case something happens to your server. Does your company have a recovery plan in place to protect its Microsoft SQL Server application Availability? Has this plan been thoroughly tested? Any loss of critical application Availability can result in decreased productivity, lost sales, lost customer confidence and potentially loss of customers. People want consistent Availability of data. The importance of backing up this server and ensuring you have a recovery plan in place is tangible. Business operations rely on a core component like Microsoft SQL Server to manage databases and data. Due to its criticality, your SQL Server and its data should be thoroughly protected. Microsoft SQL Server is often one of the most critical applications in an organization, with too many uses to count.