How do I delete Msdb log files?

How do I clean my MSDB database?

You could use the database maintenance plan – Cleanup History task and configure it to clean up backup tables automatically. Select the Cleanup History task in the maintenance plan and click Next. On the next page, select the value for the “Remove historical data older than” parameter.

Can I delete SQL transaction log files?

Note: The active transaction log file cannot be removed. Previously, we saw that once the primary log file becomes full, SQL Server uses the secondary log file. We need to make a secondary transaction log empty, so we can remove it.

How do I clear my database mail log?

Use the sysmail_delete_log_sp stored procedure to permanently delete entries from the Database Mail log. An optional argument allows you to delete only the older records by providing a date and time. Events older than that argument will be deleted.

How do I shrink MSDB log file?

The code below would shrink the MSDB database data and log files to 256 and 64 megabytes respectively. It assumes the default logical files names. This code would be run in the context of MSDB. DBCC SHRINKFILE (N'MSDBData' , 256); DBCC SHRINKFILE (N'MSDBLog' , 64);