Solved

Why my Exchange Server 2007 SP1 full backup doesn't clear up my transaction log ?

Posted on 2011-03-13
3
660 Views
Last Modified: 2013-02-22
Hi Everyone,

I'm just curious and confused, how come after full backup of my Exchange Server 2007 SP1 with CCR using HP Data Protector (A06.11) one of my Storage Group transaction log partition still not cleared ?

I wonder if there is any log file that can be safely deleted from Windows Explorer.

While the other partitions can be as low as 0.1 GB after the full backup, but only this one particular stays about 11 GB.

Any kind of help and pointer to troubleshooting this issue would be greatly appreciated.

Thanks.
0
Comment
Question by:jjoz
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
viveksahu earned 500 total points
ID: 35121502
The inactive database is updated by the active node shipping log files
to the inactive node. On the inactive node the transactions in the log
files are applied to the database. When those transactions are
successfully committed to the inactive database the inactive node
conveys that information to the active node. Once the active node
knows the log files have been committed to both copies of the database
it notes that fact and will allow those log files to be removed.
0
 
LVL 1

Author Comment

by:jjoz
ID: 35123236
Ah, so how do i know which log files are safe to be deleted from windows explorer ?

I read somewhere about  getting the database shutdown state but somehow I forgot about it.
0
 
LVL 1

Author Closing Comment

by:jjoz
ID: 35144240
thanks man !
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
how to add IIS SMTP to handle application/Scanner relays into office 365.

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

19 Experts available now in Live!

Get 1:1 Help Now