Purge SQL Server Job History causes MSDB to grow and Consume entire drive
My MSDB file is located on the C drive, everytime I try to purge the SQL Server Job History it causes the MSDB to grow and consume the entire C drive. How can I deleting old job history without the MSDB consuming the entire drive?
Purge the data in very small pieces. Rather than trying to remove it all, only remove a month or so at a time. That way the log won't have to be larger to support the larger transaction that you're creating. Unless we're talking about a development machine, it's generally considered a very bad practice to have any of the databases on the C:\ drive.