Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread: CentOS2Alma discussion
Logs should be truncated whenever you perform a full backup of the database. You can also manually truncate them. A script I found to do it a long time ago:
Code:
declare @dbname nvarchar(255)
set @dbname = 'yourdatabasenamehere'
backup log @dbname with truncate_only
DBCC SHRINKDATABASE (@dbname, 0)
Thanks I have tried doing a full backup of this database and it did not truncate the log file. How do I execute the above script? Do I save it as some kind of file and then execute it? If so what type of file should I name it?
Yes it appears that the recovery model on the troubled server are all set to full and not Simple, I switched them to simple recover model to solve the problem. Thanks.
What I do not understand is why this server is still setting up the databases using the FULL recover model, yet on a new server with PLESK 8.1 same as this server, it sets up the databases using the simple recover model? Also why is the auto close & auto shrink option not being set?