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.
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
-
- Influencer
- Posts: 13
- Liked: 1 time
- Joined: Jan 17, 2019 10:09 am
- Full Name: Fabien ROUSSILLON
- Location: Paris, FRANCE
- Contact:
-
- Product Manager
- Posts: 14417
- Liked: 1576 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: SQL Recovery model
Hello Fabien,
Thank you for the detailed explanation. We will review the case details with RnD folks. Cheers!
Thank you for the detailed explanation. We will review the case details with RnD folks. Cheers!
-
- Enthusiast
- Posts: 72
- Liked: 30 times
- Joined: Apr 22, 2016 1:06 am
- Full Name: Steven Meier
- Contact:
Re: SQL Recovery model
Any update to this as I have the same issue.
-
- Product Manager
- Posts: 14417
- Liked: 1576 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: SQL Recovery model
Hello Steven,
Please check the double check the permissions of the SQL account used for backup? Thank you in advance!
Please check the double check the permissions of the SQL account used for backup? Thank you in advance!
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Jan 08, 2020 6:50 am
- Full Name: Rebeca Wilson
- Contact:
Re: SQL Recovery model
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.
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.
Who is online
Users browsing this forum: No registered users and 14 guests