Will this prevent logs from filling-up?
Posted on 2015-01-05
Will this work? :
BACKUP DATABASE [curtis_llc] TO [curtis_llc] WITH INIT , NOUNLOAD , NAME = N'curtis_llc database', SKIP , STATS = 10, NOFORMAT
Hourly during the business day:
BACKUP LOG [curtis_llc] TO [curtis_llc] WITH NOINIT , NOUNLOAD , NAME = N'curtis_llc backup LOG', SKIP , STATS = 10, DESCRIPTION = N'LLC Log', NOFORMAT
I know this prevents my backup device from filling up since it's initialized each morning at 9am, but will this also prevent the transaction logs from filling up?
In other words, does the 9am backup truncate the logs based on the command above?
Should the hourly log backups be init or noinit?
Sorry for the total-newbie-question,