Log Shipping Question

I have successfully setup log shipping between my production SQL 2000 Server
(setup in a Cluster) and my Disaster Recovery SQL 2000 Server (across a WAN)
What is the best way if any to stop the log shipping for a extended period
of time and re-enable it without setting up the entire maintenance plan
again. Is this possible? What happened is I needed to shut down my
production server due to hurricane Wilma as a precaution. I disabled the log
shipping jobs on both servers but didn't actually physicall shut down the
Disaster Recovery SQL 2000 Server.
The servers got out of synch...although it said the logs were being shipped
and they were working correctly after I turned the production server back on.
However, the log were not being copied to the Disaster Recovery Server.
Any help would be appreciated. Thanks!!
Hello mate,
The way I understand it is you could have just shut down your production
server without changing/stopping/disabling the log shipping jobs and just
bring it back online when your happy (the hurricane has passed!) and the
backup/copy and restores should resume as normal?
The shipping jobs seems very automated once started and syncronised - think
of it like a 'long reboot' of your production boxes. Your boxes aer fine
after bouncing them right - so whats the difference if they are down for a
few days?
I'm in the middle of documenting a similar setup with my production box (non
clustered) getting logs sent to the backup SQL box accross a WAN - the most
complex part of the exercise seems to be getting the backup DB up and running
post failure/disaster of the production box.
Hope this helps you mate.
Paul.
"foghorn69@.news.postalias" wrote:

> I have successfully setup log shipping between my production SQL 2000 Server
> (setup in a Cluster) and my Disaster Recovery SQL 2000 Server (across a WAN)
> What is the best way if any to stop the log shipping for a extended period
> of time and re-enable it without setting up the entire maintenance plan
> again. Is this possible? What happened is I needed to shut down my
> production server due to hurricane Wilma as a precaution. I disabled the log
> shipping jobs on both servers but didn't actually physicall shut down the
> Disaster Recovery SQL 2000 Server.
> The servers got out of synch...although it said the logs were being shipped
> and they were working correctly after I turned the production server back on.
> However, the log were not being copied to the Disaster Recovery Server.
> Any help would be appreciated. Thanks!!

Log Shipping Question

I have successfully setup log shipping between my production SQL 2000 Server
(setup in a Cluster) and my Disaster Recovery SQL 2000 Server (across a WAN)
What is the best way if any to stop the log shipping for a extended period
of time and re-enable it without setting up the entire maintenance plan
again. Is this possible? What happened is I needed to shut down my
production server due to hurricane Wilma as a precaution. I disabled the log
shipping jobs on both servers but didn't actually physicall shut down the
Disaster Recovery SQL 2000 Server.
The servers got out of synch...although it said the logs were being shipped
and they were working correctly after I turned the production server back on.
However, the log were not being copied to the Disaster Recovery Server.
Any help would be appreciated. Thanks!!
Hello,
Based on my experience, you shall remove and recreate log shipping for this
situation becaseu the expected backup on the primary servers were not
properly created due to server shutdown.
More related information:
329133.KB.EN-US INF: Troubleshooting SQL Server 2000 Log Shipping "Out of
Sync" Errors
http://support.microsoft.com/default...B;EN-US;329133
314515.KB.EN-US INF: Frequently Asked Questions - SQL Server 2000 - Log
Shipping
http://support.microsoft.com/default...B;EN-US;314515
SQL Server 2000 How To Setup Log Shipping
http://www.microsoft.com/downloads/d...&familyid=7395
ec1b-199f-42bc-a31b-2056adf73f94
http://www.microsoft.com/technet/tre...hnet/prodtechn
ol/sql/deploy/prodspecs/logship1.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Log Shipping Question
| thread-index: AcXmR7EoN/OMKH5UTPqRcRbKocEcOg==
| X-WBNR-Posting-Host: 66.20.1.9
| From: "=?Utf-8?B?Rm9naG9ybkxlZ2hvcm4=?=" <foghornleghorn@.nospam.postalias>
| Subject: Log Shipping Question
| Date: Thu, 10 Nov 2005 14:40:03 -0800
| Lines: 17
| Message-ID: <E1996FA4-68BA-4906-9886-D05F65119C1A@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:66533
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| I have successfully setup log shipping between my production SQL 2000
Server
| (setup in a Cluster) and my Disaster Recovery SQL 2000 Server (across a
WAN)
|
| What is the best way if any to stop the log shipping for a extended
period
| of time and re-enable it without setting up the entire maintenance plan
| again. Is this possible? What happened is I needed to shut down my
| production server due to hurricane Wilma as a precaution. I disabled the
log
| shipping jobs on both servers but didn't actually physicall shut down the
| Disaster Recovery SQL 2000 Server.
|
| The servers got out of synch...although it said the logs were being
shipped
| and they were working correctly after I turned the production server back
on.
| However, the log were not being copied to the Disaster Recovery Server.
|
| Any help would be appreciated. Thanks!!
|
|
|

Log Shipping Multi Instances

Can you cross log ship across multiple instances using both servers?If I understand you correctly, then yes (Enterprise
edition only)
>--Original Message--
>Can you cross log ship across multiple instances using
both servers?
>.
>|||Cindy, what do you mean by "cross log ship"? Do you mean setting up a log
shipping pair where the primary & secondary servers are two distinct named
SQL instances on a single physical server? If so, then yes (as Jono said)
but why would you want to (I can't think of any good reasons)?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:884201c4d126$ef9e06d0$a601280a@.phx.gbl...
> If I understand you correctly, then yes (Enterprise
> edition only)
>>--Original Message--
>>Can you cross log ship across multiple instances using
> both servers?
>>.

Log Shipping Multi Instances

If I understand you correctly, then yes (Enterprise
edition only)

>--Original Message--
>Can you cross log ship across multiple instances using
both servers?
>.
>
Cindy, what do you mean by "cross log ship"? Do you mean setting up a log
shipping pair where the primary & secondary servers are two distinct named
SQL instances on a single physical server? If so, then yes (as Jono said)
but why would you want to (I can't think of any good reasons)?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:884201c4d126$ef9e06d0$a601280a@.phx.gbl...[vbcol=seagreen]
> If I understand you correctly, then yes (Enterprise
> edition only)
> both servers?
sql

Log Shipping Multi Instances

If I understand you correctly, then yes (Enterprise
edition only)

>--Original Message--
>Can you cross log ship across multiple instances using
both servers?
>.
>Cindy, what do you mean by "cross log ship"? Do you mean setting up a log
shipping pair where the primary & secondary servers are two distinct named
SQL instances on a single physical server? If so, then yes (as Jono said)
but why would you want to (I can't think of any good reasons)?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:884201c4d126$ef9e06d0$a601280a@.phx.gbl...[vbcol=seagreen]
> If I understand you correctly, then yes (Enterprise
> edition only)
>
> both servers?

Log Shipping copy with compression

I've got several secondary servers setup against my production server, and
working fine. However, one is across a t-1, and the file copying can really
effect latency across this link.
I've been searching far an wide for a "replicator" that has a client server
component, that can do streaming compression. TRNs compress down incrediably
well. I could use a util to zip them to a unc, and then unzip on the other
side, but this seems dumb. Why oh why doesn't SMB support compression...we
have gone backwards since the z-modem days .
I'm trying to get rsync to work using cygwin, but of course it is a pain in
the butt. Does anyone know of affoardable software that does this seamly
simple task. I'm about to program my own.
Compression has been considered on the packet level, but the reason that it
is not implemented is that in general the data travelling across the wire is
binary and the compression ratio and cost involved in compressing binary
data outweighs the savings in doing so. Compressing purely textual data does
provide much better compression.
Your best bet is to zip then before sending, and then unzip them on the
other end.
"et" <et@.discussions.microsoft.com> wrote in message
news:83CF2440-9764-47D7-8163-AE47C3106035@.microsoft.com...
> I've got several secondary servers setup against my production server, and
> working fine. However, one is across a t-1, and the file copying can
really
> effect latency across this link.
> I've been searching far an wide for a "replicator" that has a client
server
> component, that can do streaming compression. TRNs compress down
incrediably
> well. I could use a util to zip them to a unc, and then unzip on the other
> side, but this seems dumb. Why oh why doesn't SMB support compression...we
> have gone backwards since the z-modem days .
> I'm trying to get rsync to work using cygwin, but of course it is a pain
in
> the butt. Does anyone know of affoardable software that does this seamly
> simple task. I'm about to program my own.
>
|||As I recall Windows 2003 was supposed to offer SMB copying of NTFS compressed
files from server to server without uncompressing in the middle.
But as I've never seen that feature advertised, I'm guessing it never made the
cut before release.

> I've been searching far an wide for a "replicator" that has a client server
> component, that can do streaming compression. TRNs compress down incrediably
> well. I could use a util to zip them to a unc, and then unzip on the other
> side, but this seems dumb. Why oh why doesn't SMB support compression...we
> have gone backwards since the z-modem days .
> I'm trying to get rsync to work using cygwin, but of course it is a pain in
> the butt. Does anyone know of affoardable software that does this seamly
> simple task. I'm about to program my own.
>
Neil Pike. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Log Shipping Across Domains

We have a secure environment containing a SQL cluster, and wish to use
log shipping to ship data out to a reporting server. For various
reasons, this reporting server lives in another Win2k domain, outside
of the OLTP environment, and the two are separated by a firewall.
We don't want to set up any trusts between the domain, so what we're
trying to achieve is log shipping across two non-trusting domains.
Testing so far fails upon 'initializing destination', presumably
because the source server(s) can't write to the share on the
desintation server.
Does anyone know if what we're trying to achieve is possible, or if
there might be another solution (using something like ftp, for
example)?
Any thoughts or suggestions great appreciated,
GlenI would go for "rolling your own" version of Log Shipping (it would not be
that difficult) and perhaps using FTP to transfer the logs. Can you do
that?
Here's one article on the subject.
http://www.sql-server-performance.c...g_shipping.asp. I'd
google for more.
hth
Eric
<gsmithnospam@.cafonline.org> wrote in message
news:com8b011jv09mbomcb24fvtt3h918i730c@.
4ax.com...
> We have a secure environment containing a SQL cluster, and wish to use
> log shipping to ship data out to a reporting server. For various
> reasons, this reporting server lives in another Win2k domain, outside
> of the OLTP environment, and the two are separated by a firewall.
> We don't want to set up any trusts between the domain, so what we're
> trying to achieve is log shipping across two non-trusting domains.
> Testing so far fails upon 'initializing destination', presumably
> because the source server(s) can't write to the share on the
> desintation server.
> Does anyone know if what we're trying to achieve is possible, or if
> there might be another solution (using something like ftp, for
> example)?
> Any thoughts or suggestions great appreciated,
> Glen|||Thanks Eric - looks like that's our only option!
Glen
On Wed, 26 May 2004 09:14:45 -0400, "Eric Sabine"
<mopar41@.___ho_y_tmail.ScPoAmM> wrote:

>I would go for "rolling your own" version of Log Shipping (it would not be
>that difficult) and perhaps using FTP to transfer the logs. Can you do
>that?
>Here's one article on the subject.
>http://www.sql-server-performance.c...g_shipping.asp. I'd
>google for more.
>hth
>Eric
>
><gsmithnospam@.cafonline.org> wrote in message
> news:com8b011jv09mbomcb24fvtt3h918i730c@.
4ax.com...
>

Log Shipping Across Domains

We have a secure environment containing a SQL cluster, and wish to use
log shipping to ship data out to a reporting server. For various
reasons, this reporting server lives in another Win2k domain, outside
of the OLTP environment, and the two are separated by a firewall.
We don't want to set up any trusts between the domain, so what we're
trying to achieve is log shipping across two non-trusting domains.
Testing so far fails upon 'initializing destination', presumably
because the source server(s) can't write to the share on the
desintation server.
Does anyone know if what we're trying to achieve is possible, or if
there might be another solution (using something like ftp, for
example)?
Any thoughts or suggestions great appreciated,
Glen
I would go for "rolling your own" version of Log Shipping (it would not be
that difficult) and perhaps using FTP to transfer the logs. Can you do
that?
Here's one article on the subject.
http://www.sql-server-performance.co..._shipping.asp. I'd
google for more.
hth
Eric
<gsmithnospam@.cafonline.org> wrote in message
news:com8b011jv09mbomcb24fvtt3h918i730c@.4ax.com...
> We have a secure environment containing a SQL cluster, and wish to use
> log shipping to ship data out to a reporting server. For various
> reasons, this reporting server lives in another Win2k domain, outside
> of the OLTP environment, and the two are separated by a firewall.
> We don't want to set up any trusts between the domain, so what we're
> trying to achieve is log shipping across two non-trusting domains.
> Testing so far fails upon 'initializing destination', presumably
> because the source server(s) can't write to the share on the
> desintation server.
> Does anyone know if what we're trying to achieve is possible, or if
> there might be another solution (using something like ftp, for
> example)?
> Any thoughts or suggestions great appreciated,
> Glen
|||Thanks Eric - looks like that's our only option!
Glen
On Wed, 26 May 2004 09:14:45 -0400, "Eric Sabine"
<mopar41@.___ho_y_tmail.ScPoAmM> wrote:

>I would go for "rolling your own" version of Log Shipping (it would not be
>that difficult) and perhaps using FTP to transfer the logs. Can you do
>that?
>Here's one article on the subject.
>http://www.sql-server-performance.co..._shipping.asp. I'd
>google for more.
>hth
>Eric
>
><gsmithnospam@.cafonline.org> wrote in message
>news:com8b011jv09mbomcb24fvtt3h918i730c@.4ax.com.. .
>

Log Shipping Across Domains

We have a secure environment containing a SQL cluster, and wish to use
log shipping to ship data out to a reporting server. For various
reasons, this reporting server lives in another Win2k domain, outside
of the OLTP environment, and the two are separated by a firewall.
We don't want to set up any trusts between the domain, so what we're
trying to achieve is log shipping across two non-trusting domains.
Testing so far fails upon 'initializing destination', presumably
because the source server(s) can't write to the share on the
desintation server.
Does anyone know if what we're trying to achieve is possible, or if
there might be another solution (using something like ftp, for
example)?
Any thoughts or suggestions great appreciated,
GlenI would go for "rolling your own" version of Log Shipping (it would not be
that difficult) and perhaps using FTP to transfer the logs. Can you do
that?
Here's one article on the subject.
http://www.sql-server-performance.com/sql_server_log_shipping.asp. I'd
google for more.
hth
Eric
<gsmithnospam@.cafonline.org> wrote in message
news:com8b011jv09mbomcb24fvtt3h918i730c@.4ax.com...
> We have a secure environment containing a SQL cluster, and wish to use
> log shipping to ship data out to a reporting server. For various
> reasons, this reporting server lives in another Win2k domain, outside
> of the OLTP environment, and the two are separated by a firewall.
> We don't want to set up any trusts between the domain, so what we're
> trying to achieve is log shipping across two non-trusting domains.
> Testing so far fails upon 'initializing destination', presumably
> because the source server(s) can't write to the share on the
> desintation server.
> Does anyone know if what we're trying to achieve is possible, or if
> there might be another solution (using something like ftp, for
> example)?
> Any thoughts or suggestions great appreciated,
> Glen|||Thanks Eric - looks like that's our only option!
Glen
On Wed, 26 May 2004 09:14:45 -0400, "Eric Sabine"
<mopar41@.___ho_y_tmail.ScPoAmM> wrote:
>I would go for "rolling your own" version of Log Shipping (it would not be
>that difficult) and perhaps using FTP to transfer the logs. Can you do
>that?
>Here's one article on the subject.
>http://www.sql-server-performance.com/sql_server_log_shipping.asp. I'd
>google for more.
>hth
>Eric
>
><gsmithnospam@.cafonline.org> wrote in message
>news:com8b011jv09mbomcb24fvtt3h918i730c@.4ax.com...
>> We have a secure environment containing a SQL cluster, and wish to use
>> log shipping to ship data out to a reporting server. For various
>> reasons, this reporting server lives in another Win2k domain, outside
>> of the OLTP environment, and the two are separated by a firewall.
>> We don't want to set up any trusts between the domain, so what we're
>> trying to achieve is log shipping across two non-trusting domains.
>> Testing so far fails upon 'initializing destination', presumably
>> because the source server(s) can't write to the share on the
>> desintation server.
>> Does anyone know if what we're trying to achieve is possible, or if
>> there might be another solution (using something like ftp, for
>> example)?
>> Any thoughts or suggestions great appreciated,
>> Glen
>