sql server

[Former Member]

Hi

How can I change sql server recovery model to simple,

regards,

[Former Member]

Simply execute the below t-sql

USE master ;

ALTER DATABASE model SET RECOVERY SIMPLE ;

[Former Member]

To view or change the recovery model of a database

After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

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

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

In the Select a Page pane, click Options.

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

Optionally, to change the recovery model select a different model list. The choices are Full, Bulk-logged, or Simple.

Regards

dEE