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!

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

Truncate Transaction Log and Log Shipping

Status
Not open for further replies.
djj55

djj55

Programmer
Feb 6, 2006
1,761
0
0
US
Hello, SQL2008R2
I had posted this in the programming forum but it was suggested I move it here.

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!
 
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
76
GCL2007
GCL2007
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
62
JScannell
JScannell
RRinTetons
  • Locked
  • Question
SQL Server 2008 R2 login auditing
Replies
0
Views
68
RRinTetons
RRinTetons
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
74
fredericofonseca
fredericofonseca
JoPaBC
  • Locked
  • Question
Delphi/Borland program and SQL Express 2017
Replies
6
Views
122
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top