How to truncate the SQL reporting database transaction log file (.ldf) (4320826)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

How to truncate the SQL reporting database transaction log file (.ldf)
Beschreibung

The transaction log file (.ldf) for the SQL database is growing in size and needs to be reduced.
Lösung
1. Open SQL Management Studio
2. Expand Databases to find "RecoveryManager-Reporting-Servername"
3. Right click on the database and navigate to: Tasks | Shrink | Files
4. For the "File type" dropdown chose "Log" and click Ok
To help prevent this issue from occurring again:
1. Right click on the database and go to Properties
2. Go to Options
3. Under the "Recovery model" chose "Simple" and click Ok

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Recovery Manager for AD Disaster Recovery Edition
10.3, 10.2.2, 10.2.1, 10.2, 10.1.1, 10.1, 10.0.1, 10.0; Recovery Manager for AD Forest Edition
10.3, 10.2.2, 10.2.1, 10.2, 10.1.1, 10.1, 10.0.1, 10.0, 9.0.1, 9.0, 8.2, 8.1, 8.0.1, 8.0, 7.11.2, 7.11.1, 7.11, 7.10, 7.9, 7.6.0, 7.6.3, 7.6.2, 7.8.0, 7.7; Recovery Manager for AD
10.3, 10.2.2, 10.2.1, 10.2, 10.1.1, 10.1, 10.0.1, 10.0, 9.0.1, 8.2, 8.1, 8.0.1, 8.0, 7.11.2, 7.11.1, 7.11, 7.10, 7.9, 7.8.0, 7.7.0, 7.6.3, 7.6.2, 7.5.2, 7.6.0, 7.5.1, 7.5.0, 7.1.4, 7.1.3, 7.1.2, 7.1.1

Titel