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

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

How to set SQL database to Simple Recovery Model
Descrizione

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

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.
Risoluzione
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 inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Prodotto/i:: Archive Manager for Exchange; Archive Manager for Files

Cronologia articoli:: Data di creazione: 6/9/2017
Ultimo aggiornamento: 5/7/2023

Titolo