How to set SQL database to Simple Recovery Model (4292760)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

How to set SQL database to Simple Recovery Model
Beschreibung

SQL logs are continuing to grow, which are requiring maintenance plans and backups to shrink them
Ursache

SQL saves transactions into a log that are then committed to the database. If regular backups of the SQL databases are taken, these logs become less useful and are not needed.
Lösung
These instructions apply to all version of SQL. These instructions are valid for each sub version such as Express, Standard and Enterprise.
1. Open SQL Management Studio.
2. Connect to the instance where the Archive Manager databases are located.
3. Expand the Databases node.
4. Right-click on a database and select Properties.
5. Select Options on the left panel.
6. Change the Recovery model to Simple.
7. Click OK.
NOTE: In most cases, there are multiple databases that Archive Manager is connecting to. If there are multiple databases that Archive Manager is connecting to, as in most cases, repeat steps 4 through 7 for each database that is being used.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Archive Manager for Exchange; Archive Manager for Files

Titel