Log Shipping -SQL 2000

Is there a way to detach a database that is in warm
standby mode and attach it back in the same mode and
continue with T-logs restores ?Not to my knowledge, no.
Why would you want to do such a thing? It seems illogical.
>--Original Message--
>Is there a way to detach a database that is in warm
>standby mode and attach it back in the same mode and
>continue with T-logs restores ?
>.
>sql

Log Shipping Directory Change

Anyone know how to sucessfully change the location of the transaction
log files and still get Log Shipping to continue to work?
I went in and changed the location of where the transaction logs were
stored. The logs were sucessfully writing to the new directory, but
the copy job on the destination server was not finding them. I assume
it was still looking in the old directory, because the job was
executing successfully - it just wasn't doing anything.
I think it has to do with the setting 'Network share name for backup
directory.' You set that during set-up of log shipping, but I don't
see anywhere to edit that later on. I even tried dropping and
readding the destination server - to no avail.
Any ideas?The LogShipping Copy and Restore Jobs on the destination server are still
pointing to the old location. Thesse are jobs are created automatically
during the logshipping setup process and you can't change it. I will advice
that you remove the logshipping and created it again.
Egbon.
"Jeff Albenberg" <jalbenberg@.yahoo.com> wrote in message
news:e9dc0a21.0307290931.68bb5d1c@.posting.google.com...
> Anyone know how to sucessfully change the location of the transaction
> log files and still get Log Shipping to continue to work?
> I went in and changed the location of where the transaction logs were
> stored. The logs were sucessfully writing to the new directory, but
> the copy job on the destination server was not finding them. I assume
> it was still looking in the old directory, because the job was
> executing successfully - it just wasn't doing anything.
> I think it has to do with the setting 'Network share name for backup
> directory.' You set that during set-up of log shipping, but I don't
> see anywhere to edit that later on. I even tried dropping and
> readding the destination server - to no avail.
> Any ideas?

Log Shipping and SQL Backup

We would like to setup Log shipping to our London server from USA, Meanwhile
I would like to continue taking my normal Full/Differential or Transaction
Log backup at my other server in USA.
Is it possible? if yes then how?
Will it break log shipping?
Thanks in advance
A log backup will "break" log shipping. All you really need to remember is that log backup need to
be restore in sequence, with no gaps. You can use an older db/diff backup, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sandeep" <Sandeep@.discussions.microsoft.com> wrote in message
news:23E295D9-FCFB-49CA-B840-A3516087BBBF@.microsoft.com...
> We would like to setup Log shipping to our London server from USA, Meanwhile
> I would like to continue taking my normal Full/Differential or Transaction
> Log backup at my other server in USA.
> Is it possible? if yes then how?
> Will it break log shipping?
> Thanks in advance
>
|||It means I would be able to use Full /Diff backup along with log shipping
without breaking any of of these.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uJMQgJUmIHA.5660@.TK2MSFTNGP02.phx.gbl...
>A log backup will "break" log shipping. All you really need to remember is
>that log backup need to be restore in sequence, with no gaps. You can use
>an older db/diff backup, though.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Sandeep" <Sandeep@.discussions.microsoft.com> wrote in message
> news:23E295D9-FCFB-49CA-B840-A3516087BBBF@.microsoft.com...
>
|||Yes. Just make sure you don't do anything strange like setting the database to simple recovery or
BACKUP LOG ... WITH TRUNCATE_ONLY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sandeep Shankar" <sandeep@.nospam.com> wrote in message
news:uOf94PmmIHA.5820@.TK2MSFTNGP04.phx.gbl...
> It means I would be able to use Full /Diff backup along with log shipping without breaking any of
> of these.
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uJMQgJUmIHA.5660@.TK2MSFTNGP02.phx.gbl...
>

Log Shipping and SQL Backup

We would like to setup Log shipping to our London server from USA, Meanwhile
I would like to continue taking my normal Full/Differential or Transaction
Log backup at my other server in USA.
Is it possible? if yes then how?
Will it break log shipping?
Thanks in advanceA log backup will "break" log shipping. All you really need to remember is that log backup need to
be restore in sequence, with no gaps. You can use an older db/diff backup, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sandeep" <Sandeep@.discussions.microsoft.com> wrote in message
news:23E295D9-FCFB-49CA-B840-A3516087BBBF@.microsoft.com...
> We would like to setup Log shipping to our London server from USA, Meanwhile
> I would like to continue taking my normal Full/Differential or Transaction
> Log backup at my other server in USA.
> Is it possible? if yes then how?
> Will it break log shipping?
> Thanks in advance
>|||It means I would be able to use Full /Diff backup along with log shipping
without breaking any of of these.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uJMQgJUmIHA.5660@.TK2MSFTNGP02.phx.gbl...
>A log backup will "break" log shipping. All you really need to remember is
>that log backup need to be restore in sequence, with no gaps. You can use
>an older db/diff backup, though.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Sandeep" <Sandeep@.discussions.microsoft.com> wrote in message
> news:23E295D9-FCFB-49CA-B840-A3516087BBBF@.microsoft.com...
>> We would like to setup Log shipping to our London server from USA,
>> Meanwhile
>> I would like to continue taking my normal Full/Differential or
>> Transaction
>> Log backup at my other server in USA.
>> Is it possible? if yes then how?
>> Will it break log shipping?
>> Thanks in advance
>|||Yes. Just make sure you don't do anything strange like setting the database to simple recovery or
BACKUP LOG ... WITH TRUNCATE_ONLY.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sandeep Shankar" <sandeep@.nospam.com> wrote in message
news:uOf94PmmIHA.5820@.TK2MSFTNGP04.phx.gbl...
> It means I would be able to use Full /Diff backup along with log shipping without breaking any of
> of these.
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uJMQgJUmIHA.5660@.TK2MSFTNGP02.phx.gbl...
>>A log backup will "break" log shipping. All you really need to remember is that log backup need to
>>be restore in sequence, with no gaps. You can use an older db/diff backup, though.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Sandeep" <Sandeep@.discussions.microsoft.com> wrote in message
>> news:23E295D9-FCFB-49CA-B840-A3516087BBBF@.microsoft.com...
>> We would like to setup Log shipping to our London server from USA, Meanwhile
>> I would like to continue taking my normal Full/Differential or Transaction
>> Log backup at my other server in USA.
>> Is it possible? if yes then how?
>> Will it break log shipping?
>> Thanks in advance
>>
>