I have jobs in place to trim tables used for history and logging 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
The database is in simple recovery mode.