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.
| 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? CheersArnavEven 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? CheersArnavEven 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? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
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.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
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 :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Log Shipping Doubt