Translog backup of auto_close databases

Availability for the Always-On Enterprise

Translog backup of auto_close databases

Veeam Logoby toreml » Fri 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
toreml
Influencer
 
Posts: 24
Liked: never
Joined: Wed Sep 13, 2017 11:12 am
Full Name: Tore Mejlænder-Larsen

Re: Translog backup of auto_close databases

Veeam Logoby foggy » Fri Apr 13, 2018 2:15 pm

Hi Tore, unfortunately, nothing they can do other than disable that option.
foggy
Veeam Software
 
Posts: 16306
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Translog backup of auto_close databases

Veeam Logoby toreml » Fri 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
toreml
Influencer
 
Posts: 24
Liked: never
Joined: Wed Sep 13, 2017 11:12 am
Full Name: Tore Mejlænder-Larsen

Re: Translog backup of auto_close databases

Veeam Logoby foggy » Mon 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.
foggy
Veeam Software
 
Posts: 16306
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Samba222 and 51 guests