Log is going to backup itself every one hour | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Log is going to backup itself every one hour

<font size="3">Hi all,<br />We have many messages in SQL server logs that say ‘Log backed up<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />atabase:COM,creation date(time):2003/03/26(19:41:5<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />,first'<br />why is this message appeared every one hour?</font id="size3">
What recovery model COM database has?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
hi LuisMartin
Recovery model is FUll.
regards
So, if full, then you may have a transaction log backup every hour. Could be?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
We have only one FUll backup every day.
thanks
Well, in this case, wait for others oppinions because I really don’t know why you have that message.
BTW: I suggest to change recovery model to simple, because full is usefull if you backup transaction log every, said, 2-4 hours.
Full means big transaction log using disk space. Simple reduce log.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Check whether you’ve any maintenance plan that includes Transaction log backups scheduled every one hour and moreover this is not an issue to look after and on the recovery model let it be FULL which has major advantage on other recovery models. Until unless any scheduled job created to backup the log, SQL Server will not backup transaction log on its own. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
You also might want to check with your server/network group. They could have an agent like Veritas running that does a transaction log backup every hour for you. This would be my "stab in the dark". MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>