IBM Support

How do you set the database recovery model in SQL Server to Simple?

Question & Answer


Question

How do you set the database recovery model in SQL Server to Simple?

Answer

Contents

Question

How do you set the database recovery model in SQL Server to Simple?

Answer
In SQL Server Management Studio (2005 and 2008):
  1. Right-click on the Database name and select Properties.
  2. On the Options tab identify the drop-down list: Recovery Model.
  3. Select Simple from the list.
  4. Apply the changes.
Article Reference
00000342

Applies to version(s):? 7.x;8.x
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
Tealeaf Customer Experience

Software version:
All Versions

Document number:
776547

Modified date:
08 December 2018

UID

ibm10776547

Manage My Notification Subscriptions