Shrinking SABA Log files
We have SABA for our learning management system and from time to time the log files get out of control.
This script will shrink them USE Saba_prod_tp2; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE Saba_prod_tp2 SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (tp2_Log, 10); GO -- Reset the database recovery model. ALTER DATABASE Saba_Uat_tp2 SET RECOVERY FULL; GO
USE Saba_Uat_tp2; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE Saba_Uat_tp2 SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (tp2_Log, 10); GO -- Reset the database recovery model. ALTER DATABASE Saba_Uat_tp2 SET RECOVERY FULL; GO

Leave a Reply
You must be logged in to post a comment.