I have jobs in place to trim tables used for history and logging so to keep them trim. I want to make sure I don't neglect the log file.
How and what can I or should I do to keep the log file in check?
The sql script I have running on a nightly schedule is:
declare @DBname varchar(500) set @DBname = 'E:\Database\backup\PMIS_backup_'+ convert(varchar(MAX), getdate(), 23 ) +'.bak' BACKUP DATABASE [PMIS] TO DISK = @DBname WITH NOFORMAT, NOINIT, NAME = @DBname , SKIP, REWIND, NOUNLOAD, STATS = 10
(recovery mode is simple)