How to truncate Avidian SQL log files

Frequently asked questions and support articles for Prophet On-Premise hosted customers with their own servers.

Moderator: Prophet Support

Locked
User avatar
admin
Site Admin
Posts: 68
Joined: Mon Dec 04, 2017 2:40 pm

How to truncate Avidian SQL log files

Post by admin » Wed Jun 27, 2018 12:16 pm

How to Truncate Avidian's SQL Log File

Symptoms
  • If there is not an automatic backup set for your Avidian database, the Log file may build up to a size that makes Prophet unusable for anyone due to disk space issues.
  • To setup automatic backups to prevent this in the future you may use the Microsoft Article below to avoid this issue.
    https://support.microsoft.com/en-us/hel ... -in-sql-se
Solutions
  1. Login to your On-Premise SQL Server via Microsoft SQL Server Management Studio
  2. Right click the 'Avidian' database folder and select 'Properties'
  3. Click the 'Options' page and change the Recovery mode from 'Full' to 'Simple' (Or leave it on Simple if already set)
    Image
  4. Click 'OK' to save your changes
  5. Right-click on the 'Avidian' database again, highlight Tasks->Shrink and then click 'Files'
    Image
  6. In the 'Shrink File' window, select 'Log' from the 'File Type:' drop down box. Also make sure 'Reorganize pages before releasing unused space' option is filled in
    Image
  7. Click 'OK' to truncate the log
  8. Once complete, Right click the 'Avidian' database folder again, and select 'Properties'
  9. Click 'Options' on the left and Change the 'Recovery Model' back to 'Full'
  10. Click 'OK'. Your Log has now been truncated
Hidden Content
This board requires you to be registered and logged-in to view hidden content.

Locked
  • Similar Topics
    Replies
    Views
    Last post
  • How Do I Re-Register Prophet's DLL Files?
    by admin » Sat Mar 10, 2018 2:16 pm » in FAQ
    0 Replies
    480 Views
    Last post by admin
    Sat Mar 10, 2018 2:16 pm
  • Default Unmodified Web.Config Files
    by admin » Fri Jun 29, 2018 9:46 am » in Prophet On-Premise Server Support
    0 Replies
    2494 Views
    Last post by admin
    Fri Jun 29, 2018 9:46 am