- Posts: 13
- Liked: 1 time
- Joined: Jan 17, 2019 10:09 am
- Full Name: Fabien ROUSSILLON
- Location: Paris, FRANCE
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 ?
- Posts: 1
- Liked: never
- Joined: Jan 08, 2020 6:50 am
- Full Name: Rebeca Wilson
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.
Users browsing this forum: No registered users and 2 guests