Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transaction Log Truncate and Log Shipping

Status
Not open for further replies.

djj55

Programmer
Feb 6, 2006
1,761
US
Hello, SQL2008R2
We backup our database regularly. We also have Log Shipping setup.

My question is, if I want to truncate the transaction log (BACKUP LOG) after backing up the database, will this break log shipping?
I was thinking of doing this on Saturday nights to keep the log file from getting too large as we have limited space.

Is there a commit for the transaction log that needs done?

Thanks

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Probably better asked in the Setup and Administration forum.

-----------
With business clients like mine, you'd be better off herding cats.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top