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: 10987
Liked: 915 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: 50
Liked: 29 times
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: 10987
Liked: 915 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!

rebeca
Lurker
Posts: 1
Liked: never
Joined: Jan 08, 2020 6:50 am
Full Name: Rebeca Wilson
Contact:

Re: SQL Recovery model

Post by rebeca » Jan 08, 2020 7:00 am

You can view the SQL recovery model by using SQL Server Management Studio. Follow these steps for the same.

1. Connect to the appropriate instance of the SQL Server database engine and then click the server name in Object Explorer to expand the server tree.

2. Expand Databases and, depending on the database, either select a user database, or expand system databases and select a system database.

3. Right-click the database, and then click Properties. The Database Properties dialog box opens.

4. In the Select a page area, click Options.

5. The current recovery model is displayed in the Recovery model list box.

6. To change the recovery model, optionally choose a different model list. The selection options are "Full", "Bulk logged" or "Simple".

7. Finally, click OK.

In addition, if you have corrupted SQL database files, you can use the SQL Recovery tool. This will allow you to repair corrupt MDF and NDF files with all objects. It is also able to recover deleted records from the SQL table.

Post Reply

Who is online

Users browsing this forum: JLE2x20 and 5 guests