SQL Transaction log is not being backed up
Posted on 2007-11-22
Got 11d for windows 2003
Got windows 2003, exchange, Adavanced OFO and sql agents on
When the SQL server is being backed up (remote agent used)
Not enabled Advanced OFO.
When backup occurs, SQL database gets backed up but NOT transaction log.,.. so log is steadlily increasing in size an dproperties of db shows it has not been backed up for a while
I can see under the SQL option in the backup setup, that I can change it to 'log file' instead of FULL.
I thought FULL would include TLog and therefore backup etc..
I could enable Advanced OFO.. but considering nothing is open but exchange and sql and other usual like virus scan etc.. thought maybe will be ok as I saw FULL option and now TLog option.
Is this something whereby I must enable Advanced OFO or do I need to do another backup daily for just the TLog (seems odd)