Logs Shipping ReInit - how to?

We have setup Log Shipping in SQL 2005. Working flawlessly. It appears that
only tran log backup will occur forever unless we intervene. I do want a full
backup to happen, you know, eventually...
What is best way to automate this? Ideally, a full backup nightly would be
great. How to do in script, or is there anything in gui?
tia,
chrisYou want a full backup of the primary? Just do Backup database...
You cannot backup the secondary as far as I know.
If you want to re-init log shipping and start clean on a system that LS is
working flawlessly on, you aer simply wasting bandwidth and cpu. :)
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:2E07F579-4A8A-47B6-B457-D7B543F00086@.microsoft.com...
> We have setup Log Shipping in SQL 2005. Working flawlessly. It appears
> that
> only tran log backup will occur forever unless we intervene. I do want a
> full
> backup to happen, you know, eventually...
> What is best way to automate this? Ideally, a full backup nightly would be
> great. How to do in script, or is there anything in gui?
> tia,
> chris|||I can't "just do backup database..." this will break log shipping. Correct?
I'm concerned w/ primary - to start log shipping you do a full backup to
init, then tran log backups thereafter w/ each log shipped to secondary. I DO
NOT want to do tran log backups forever... I eventually would like to do a
full backup.
Am I missing somehting...?
cb
"Kevin3NF" wrote:
> You want a full backup of the primary? Just do Backup database...
> You cannot backup the secondary as far as I know.
> If you want to re-init log shipping and start clean on a system that LS is
> working flawlessly on, you aer simply wasting bandwidth and cpu. :)
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:2E07F579-4A8A-47B6-B457-D7B543F00086@.microsoft.com...
> >
> > We have setup Log Shipping in SQL 2005. Working flawlessly. It appears
> > that
> > only tran log backup will occur forever unless we intervene. I do want a
> > full
> > backup to happen, you know, eventually...
> >
> > What is best way to automate this? Ideally, a full backup nightly would be
> > great. How to do in script, or is there anything in gui?
> >
> > tia,
> > chris
>
>|||Full backups do NOT break the log chain sequence so you can do a FULL backup
at any time. The next log backup after a FULL backup will still capture any
transactions since the previous Log backup, regardless of if there was a
FULL in between or not.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:D69D6BFF-3674-4894-92DF-35EB8261E9DA@.microsoft.com...
> I can't "just do backup database..." this will break log shipping.
> Correct?
> I'm concerned w/ primary - to start log shipping you do a full backup to
> init, then tran log backups thereafter w/ each log shipped to secondary. I
> DO
> NOT want to do tran log backups forever... I eventually would like to do a
> full backup.
> Am I missing somehting...?
> cb
> "Kevin3NF" wrote:
>> You want a full backup of the primary? Just do Backup database...
>> You cannot backup the secondary as far as I know.
>> If you want to re-init log shipping and start clean on a system that LS
>> is
>> working flawlessly on, you aer simply wasting bandwidth and cpu. :)
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>> "Chris" <Chris@.discussions.microsoft.com> wrote in message
>> news:2E07F579-4A8A-47B6-B457-D7B543F00086@.microsoft.com...
>> >
>> > We have setup Log Shipping in SQL 2005. Working flawlessly. It appears
>> > that
>> > only tran log backup will occur forever unless we intervene. I do want
>> > a
>> > full
>> > backup to happen, you know, eventually...
>> >
>> > What is best way to automate this? Ideally, a full backup nightly would
>> > be
>> > great. How to do in script, or is there anything in gui?
>> >
>> > tia,
>> > chris
>>|||Also, taking DIFFERENTIAL BACKUP would NOT break the log sequence.
However taking TRANSACTION LOG backup (other than the automated jobs of Log
Shipping itself) would break the chain.
--
Ekrem Ã?nsoy
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:D69D6BFF-3674-4894-92DF-35EB8261E9DA@.microsoft.com...
> I can't "just do backup database..." this will break log shipping.
> Correct?
> I'm concerned w/ primary - to start log shipping you do a full backup to
> init, then tran log backups thereafter w/ each log shipped to secondary. I
> DO
> NOT want to do tran log backups forever... I eventually would like to do a
> full backup.
> Am I missing somehting...?
> cb
> "Kevin3NF" wrote:
>> You want a full backup of the primary? Just do Backup database...
>> You cannot backup the secondary as far as I know.
>> If you want to re-init log shipping and start clean on a system that LS
>> is
>> working flawlessly on, you aer simply wasting bandwidth and cpu. :)
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>> "Chris" <Chris@.discussions.microsoft.com> wrote in message
>> news:2E07F579-4A8A-47B6-B457-D7B543F00086@.microsoft.com...
>> >
>> > We have setup Log Shipping in SQL 2005. Working flawlessly. It appears
>> > that
>> > only tran log backup will occur forever unless we intervene. I do want
>> > a
>> > full
>> > backup to happen, you know, eventually...
>> >
>> > What is best way to automate this? Ideally, a full backup nightly would
>> > be
>> > great. How to do in script, or is there anything in gui?
>> >
>> > tia,
>> > chris
>>