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.