Shulou(Shulou.com)05/31 Report--

How to configure the SQL Server database recovery model, in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

The following are two main ways to configure the SQL Server database recovery model.

Using T-SQL to set the recovery model you can use the "ALTER DATABASE" command plus the "SET RECOVERY" statement to modify the recovery model of the database. For example, the following query sets the recovery model for the "AdventureWorks" database to full recovery.

ALTER DATABASE AdventureWorks SET RECOVERY FULL

You can query the catalog view of "sys.databases" to verify the recovery model status of the database. The statement is as follows:

SELECT name, recovery_model, recovery_model_desc FROM sys.databases WHERE name = 'AdventureWorks'

You can use the following statement to set the database to a mass operation mode or a simple recovery model, just replace it with the name of your own database at the "" location.

-Changing recovery model to Bulk-loggedALTER DATABASE AdventureWorks SET RECOVERY BULK_LOGGED;-Changing recovery model to SimpleALTER DATABASE AdventureWorks SET RECOVERY SIMPLE

When you create a new database, it inherits the recovery model from the model database, and the default is the full recovery model. To change the default recovery model, you can use the "ALTER DATABASE" statement to modify the recovery model of the model database. Note that if you plan to maintain consistent transaction log backups, you cannot switch to the simple recovery model, nor can you change from the simple recovery model to something else.

Using the SQL Server Management tool (SSMS) to modify the recovery model you can modify the recovery model of the database in the SQL Server management tool. In the object browser, right-click your database (under the database node), and then click Properties. In the Database Properties dialog box, click the options tab, and then modify the recovery model as follows:

This is the answer to the question on how to configure the SQL Server database recovery model. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.