Solved

SQL Transaction log is not being backed up

Posted on 2007-11-22
4
604 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

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
exchange, storage, vmware 19 93
Import data to Office 365 - SharePoint 6 75
How to check the PVU´s on AIX TSM servers? 3 74
My reclamation process on TSM is failing. 2 65
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

914 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now