Availability for the Always-On Enterprise
Post Reply
toreml
Enthusiast
Posts: 29
Liked: never
Joined: Sep 13, 2017 11:12 am
Full Name: Tore Mejlænder-Larsen
Contact:

Translog backup of auto_close databases

Post by toreml » Apr 13, 2018 6:24 am

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
Veeam Software
Posts: 16689
Liked: 1343 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Translog backup of auto_close databases

Post by foggy » Apr 13, 2018 2:15 pm

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

toreml
Enthusiast
Posts: 29
Liked: never
Joined: Sep 13, 2017 11:12 am
Full Name: Tore Mejlænder-Larsen
Contact:

Re: Translog backup of auto_close databases

Post by toreml » Apr 13, 2018 7:39 pm

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
Veeam Software
Posts: 16689
Liked: 1343 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Translog backup of auto_close databases

Post by foggy » Apr 16, 2018 11:55 am

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

Post Reply

Who is online

Users browsing this forum: adamspn, Baidu [Spider], Bing [Bot] and 41 guests