Translog backup of auto_close databases

[toreml]

Hi.
We have a server which have two SQL databases in full recovery mode and auto_close enabled.
The problem is that we are not able to do translog backup of those databases.
Other databases on the same server which are in full recovery model are running OK.

I've asked the DBA to disable the auto_close - but he can't do this without customer saying OK.

Anything else we can try?


Tore

[foggy]

Hi Tore, unfortunately, nothing they can do other than disable that option.

[toreml]

Hi Foggy.

Thanks for your reply.
I've also talked to others and they say the same.
I will have to talk to the customer and have them to set the database to Simple or disable auto_close.

Tore

[foggy]

Simple will not work, the database must use the Full or Bulk-logged recovery model. Otherwise logs backup is not possible.

[TheBrain82]

Hello,
I need to bring up this old post again.

Is this SQL-Server autoclose topic still "state of the art" with Veeam V12.1? It seems so because I just saw such a message for one of our customers here. Anyway, why this limitation (Veeam does not support transaction log backup of SQL-Databases where autoclose is enabled) is not mentioned anywhere in any Veeam guide?

It should be in here https://helpcenter.veeam.com/docs/backu ... ml?ver=120 but it is not! Or should it work with V12.1 now?

Thank you

[secpet]

Hi,
I found that AutoClose-DBs are excluded in v11: https://helpcenter.veeam.com/archive/ba ... stats.html
My experience with v12 is the same. Logs say "Skipping AutoClose database".
I sort of understand if it is difficult to take log-backups on a closed database.

will ask the supplier if its ok to turn it off. In my case its a SQL Express edition and i think AutoClose is on by default.

For some it might be doable to create jobs turning off during backup window and then back on.
ALTER DATABASE [DBName] SET AUTO_CLOSE OFF;
ALTER DATABASE [DBName] SET AUTO_CLOSE ON;

[david.cesar]

Hi, this is documented on the System Requirements section of the User Guide https://helpcenter.veeam.com/docs/backu ... ml?ver=120

Consider the following:

By default, the AUTO_CLOSE option for Microsoft SQL Server databases is set to False.
If AUTO_CLOSE is enabled, your databases may be skipped from processing.

Regards