[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

log shipping

Prince

3/28/2007 1:38:00 PM

Hi,

When logshipping is enabled for a DB it truncates the log files after the
backup. Now is it possible to make logshipping not to truncate the log files
on the primary server?

thanks and regards
prince
7 Answers

Uri Dimant

3/28/2007 1:51:00 PM

0

prince

It removes inactive portion (commited transactions) from the LOG. I don't
understand what is your concern?

"prince" <prince@discussions.microsoft.com> wrote in message
news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
> Hi,
>
> When logshipping is enabled for a DB it truncates the log files after the
> backup. Now is it possible to make logshipping not to truncate the log
> files
> on the primary server?
>
> thanks and regards
> prince


Prince

3/28/2007 2:26:00 PM

0

Hi Uri Dimant,

Thanks for your prompt reply. My concern is ...
I am using third party backup solution for disaster recovery. For backup
purpose i need to backup log files too but with LS enabled the inactive logs
are removed from server. Is there any alternative to overcome this?

"Uri Dimant" wrote:

> prince
>
> It removes inactive portion (commited transactions) from the LOG. I don't
> understand what is your concern?
>
> "prince" <prince@discussions.microsoft.com> wrote in message
> news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
> > Hi,
> >
> > When logshipping is enabled for a DB it truncates the log files after the
> > backup. Now is it possible to make logshipping not to truncate the log
> > files
> > on the primary server?
> >
> > thanks and regards
> > prince
>
>
>

Prince

3/28/2007 2:28:00 PM

0

Hi Uri Dimant,

Thanks for your prompt reply. My concern is ...
I am using third party backup solution for disaster recovery. For backup
purpose i need to backup log files too but with LS enabled the inactive logs
are removed from server. Is there any alternative to overcome this?


"Uri Dimant" wrote:

> prince
>
> It removes inactive portion (commited transactions) from the LOG. I don't
> understand what is your concern?
>
> "prince" <prince@discussions.microsoft.com> wrote in message
> news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
> > Hi,
> >
> > When logshipping is enabled for a DB it truncates the log files after the
> > backup. Now is it possible to make logshipping not to truncate the log
> > files
> > on the primary server?
> >
> > thanks and regards
> > prince
>
>
>

TheSQLGuru

3/28/2007 3:21:00 PM

0

Stop using Log Shipping and build your own "log shipper". That is what I
did, and it has been working like a champ for months for over 6000
databases! :-)

--
TheSQLGuru
President
Indicium Resources, Inc.

"prince" <prince@discussions.microsoft.com> wrote in message
news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
> Hi,
>
> When logshipping is enabled for a DB it truncates the log files after the
> backup. Now is it possible to make logshipping not to truncate the log
> files
> on the primary server?
>
> thanks and regards
> prince


Tibor Karaszi

3/28/2007 3:38:00 PM

0

No, you need to integrate the log shipping with your backup strategy.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://www.solidqualitylea...


"prince" <prince@discussions.microsoft.com> wrote in message
news:9B434AE1-3C2E-4AA1-B93F-AC4C3E8AA4A9@microsoft.com...
> Hi Uri Dimant,
>
> Thanks for your prompt reply. My concern is ...
> I am using third party backup solution for disaster recovery. For backup
> purpose i need to backup log files too but with LS enabled the inactive logs
> are removed from server. Is there any alternative to overcome this?
>
> "Uri Dimant" wrote:
>
>> prince
>>
>> It removes inactive portion (commited transactions) from the LOG. I don't
>> understand what is your concern?
>>
>> "prince" <prince@discussions.microsoft.com> wrote in message
>> news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
>> > Hi,
>> >
>> > When logshipping is enabled for a DB it truncates the log files after the
>> > backup. Now is it possible to make logshipping not to truncate the log
>> > files
>> > on the primary server?
>> >
>> > thanks and regards
>> > prince
>>
>>
>>


Prince

3/29/2007 4:20:00 AM

0

Hi,
Thanks.

Can you give a brief about how have u done? did u use SQL sp or implemented
in other way?

thanks and regards
prince

"TheSQLGuru" wrote:

> Stop using Log Shipping and build your own "log shipper". That is what I
> did, and it has been working like a champ for months for over 6000
> databases! :-)
>
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
>
> "prince" <prince@discussions.microsoft.com> wrote in message
> news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
> > Hi,
> >
> > When logshipping is enabled for a DB it truncates the log files after the
> > backup. Now is it possible to make logshipping not to truncate the log
> > files
> > on the primary server?
> >
> > thanks and regards
> > prince
>
>
>

Uri Dimant

3/29/2007 6:00:00 AM

0

Hi
http://www.sql-server-performance.com/sql_server_log_sh...





"prince" <prince@discussions.microsoft.com> wrote in message
news:B05DF092-1F57-4E1F-92EC-57B227D9CD34@microsoft.com...
> Hi,
> Thanks.
>
> Can you give a brief about how have u done? did u use SQL sp or
> implemented
> in other way?
>
> thanks and regards
> prince
>
> "TheSQLGuru" wrote:
>
>> Stop using Log Shipping and build your own "log shipper". That is what I
>> did, and it has been working like a champ for months for over 6000
>> databases! :-)
>>
>> --
>> TheSQLGuru
>> President
>> Indicium Resources, Inc.
>>
>> "prince" <prince@discussions.microsoft.com> wrote in message
>> news:A589A070-416F-4E55-BAA6-EFA63F579502@microsoft.com...
>> > Hi,
>> >
>> > When logshipping is enabled for a DB it truncates the log files after
>> > the
>> > backup. Now is it possible to make logshipping not to truncate the log
>> > files
>> > on the primary server?
>> >
>> > thanks and regards
>> > prince
>>
>>
>>