Discussions specific to managed agent-based backups
Post Reply
nanii-60
Influencer
Posts: 13
Liked: 1 time
Joined: Jan 17, 2019 10:09 am
Full Name: Fabien ROUSSILLON
Location: Paris, FRANCE
Contact:

SQL Recovery model

Post by nanii-60 » Feb 18, 2019 2:11 pm

Hello !
How is it possible to see the "recovery model" of databases? Currently everything is "Unknown", yet our SQL user has all rights on its SQL database.
Image
Image

I also noticed that if I put a windows account instead of an SQL account, with the same rights on the database, it works ! I have the recovery model...
Someone has an explanation ?


CASE 03415898

Dima P.
Product Manager
Posts: 10296
Liked: 833 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Recovery model

Post by Dima P. » Feb 18, 2019 7:09 pm

Hello Fabien,

Thank you for the detailed explanation. We will review the case details with RnD folks. Cheers!

StevenMeier
Enthusiast
Posts: 48
Liked: 1 time
Joined: Apr 22, 2016 1:06 am
Full Name: Steven Meier
Contact:

Re: SQL Recovery model

Post by StevenMeier » Jun 24, 2019 8:51 pm

Any update to this as I have the same issue.

Dima P.
Product Manager
Posts: 10296
Liked: 833 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Recovery model

Post by Dima P. » Jun 25, 2019 4:45 pm

Hello Steven,

Please check the double check the permissions of the SQL account used for backup? Thank you in advance!

Post Reply

Who is online

Users browsing this forum: teeling and 6 guests