Probleme mit SQL Backup

Hello Oliver,

It's Evgeny from Acronis Service Provider Support. 

The issue appeared as there were warnings during backup.

We are running SQL statement 'CREATE TABLE during backup to make backup/log truncation pair consistent. We create transaction, create table and hold it until backup finished.

To avoid warning either give user sufficient rights to create table or turn off log truncation. In the latter case automatic log truncation can be accomplished by switching database recovery model to 'SIMPLE'.

1.

Turn off log truncation in backup plan options 

2.
Go to Microsoft SQL Server Management Studio and change Recovery Model to Simple in database properties

Please let me know if this helps you resolve the issue.

Otherwise please reach out to our Support team.

Best Regards,

Evgeny Ryuntyu | Senior Support Engineer

Acronis 

Hi, Here I would like to refer an excellent third party software, Kernel for SQL Recovery software. The software is capable to resolve all kind of issues related to SQL server.