SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Log Shipping Doubt
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sunsanvin
Flowing Fount of Yak Knowledge

India
1274 Posts

Posted - 06/25/2013 :  12:08:17  Show Profile  Send sunsanvin a Yahoo! Message  Reply with Quote
Hi Team,
I've logshipping configured, and is working fine on sql server 2005 environment.

now my doubt is If I truncate the log of primary database, will my loghsipping work or fail?

Cheers

Arnav
Even you learn 1%, Learn it with 100% confidence.

James K
Flowing Fount of Yak Knowledge

3712 Posts

Posted - 06/25/2013 :  14:27:15  Show Profile  Reply with Quote
quote:
Originally posted by sunsanvin

Hi Team,
I've logshipping configured, and is working fine on sql server 2005 environment.

now my doubt is If I truncate the log of primary database, will my loghsipping work or fail?

Cheers

Arnav
Even you learn 1%, Learn it with 100% confidence.

If you have log shipping set up, you shouldn't need to truncate the log file. Besides, you cannot truncate the (inactive portion of the) log file until you backup the log, which happens as part of log shipping.

I may have misunderstood your question. How are you truncating the log?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 06/25/2013 :  16:21:23  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you truncate the transaction log, you will break log shipping as it invalidates the log shipping chain. The chain must remain intact for log shipping and really all point-in-time recovery. So if you must do this for some odd reason, you'll need to rebuild log shipping.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sunsanvin
Flowing Fount of Yak Knowledge

India
1274 Posts

Posted - 07/04/2013 :  08:03:40  Show Profile  Send sunsanvin a Yahoo! Message  Reply with Quote
Thanks for Answer James/ Tara.
Actually, i've not tried that. that was an interview question, one of my friends faced. so to get more info I posted this question. Thanks again.

Arnav
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

sophie1
Starting Member

17 Posts

Posted - 07/04/2013 :  18:07:51  Show Profile  Reply with Quote
Trans log truncates at every checkpoint ,so we dont have to truncate it.
Please correct if im wrong,IM under learning stage :)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 07/05/2013 :  16:30:30  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by sophie1

Trans log truncates at every checkpoint ,so we dont have to truncate it.
Please correct if im wrong,IM under learning stage :)




That is not correct.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000