Veeam B&R restore SQL items and Firewall
I have a customer with some SQL servers on a DMZ, that they need to restore databases to, and we looked at the documentation for which ports to open. This is the documentation for Veeam B&R 9.0, and we found the ports and it worked fine, until we had to restore to an SQL instance…
Veeam Backup warning “Unable to truncate Microsoft SQL Server transaction logs.”
I had a customer that contacted me to day because he got a warning that Veeam Backup was "Unable to truncate Microsoft SQL Server transaction logs.Details: Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances: BI See guest helper log." This normally means that the account used for Application Aware backup is not…
Veeam B&R SQL Log Shipping and Firewall Rules
I was looking at which ports that should be open in a Firewall, for SQL log Shipping to work, so I was looking at the "VM Guest OS Connection" section of the documentation: https://helpcenter.veeam.com/backup/vsphere/used_ports.html#guest But that is not all that needs to be opened you also have to look at the "Backup Server Connections" section and…
Microsoft SQL database restore with Veeam Backup & Replicator 8.0
There are some prerequisite that is need to be in place before you can do at restore of Microsoft SQL Server databases with Veeam, on the SQL server: TCP/IP enabled as SQL Server protocol enabled remote accesss to SQL Server SQL Server Browser Server enbled and running
Veeam and SQL Backup, Truncate Log
I had a customer where we had installed Veeam backup and configured it to take backup of a SQL server,after some days the customer contacted med, that one of the log drives on the SQL was running full. The backup job was running with no errors and in job could we see that it had…