Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Log Shipping Doubt

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2013-06-25 : 12:08:17
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-25 : 14:27:15
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

38200 Posts

Posted - 2013-06-25 : 16:21:23
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
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2013-07-04 : 08:03:40
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 - 2013-07-04 : 18:07:51
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

38200 Posts

Posted - 2013-07-05 : 16:30:30
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
   

- Advertisement -