Solved

SQL Transaction log is not being backed up

Posted on 2007-11-22
4
608 Views
Last Modified: 2013-12-01
Hey all,

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)

Thanks

R
0
Comment
Question by:roycasella
  • 2
4 Comments
 
LVL 25

Expert Comment

by:imitchie
ID: 20336236
these two together should help

where it states "To select SQL data, click the domain icon or icons that contain the SQL installations, and then click the actual computer icon that contains the SQL installations. If you are using a cluster server, make backup selections from virtual server." They should point out that you need to select the db associated with the ldf you want to backup from the SQL node, not the transaction log file itself.

truncate it
http://www.experts-exchange.com/Storage/Backup_Restore/Q_22826496.html
0
 
LVL 2

Accepted Solution

by:
Neer_Thadarai earned 500 total points
ID: 20525093
The Full backup of SQL database doesn't truncate the SQL logs. Infact Backup Exec Doesn't truncate the SQL logs at all. If you do the log backup for SQL it marks them for truncate but you need to run some SHRINK command from SQL to shrink the log size.
Please refer this Article.
http://support.veritas.com/docs/270043
0
 
LVL 7

Author Comment

by:roycasella
ID: 22214636
Many Thanks

I wanted it to be an all in one process.

Have shrunk manually

Many thanks for your help..

R
0
 
LVL 7

Author Closing Comment

by:roycasella
ID: 31410588
Did not give me the 1x step process,

However, was answered correctly .. hence the A
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question