SQL 2000 log shipping question - Microsoft SQL Server

Jason Huang

Hi,

In the MS SQL 2000 Server, if the log shipping is set up right, does that
mean data in primary server changed will mapped to secondary server later
on?
Thanks.

Jason

Jul 23 '05 #1

Subscribe Reply

2124

Simon Hayes

"Jason Huang" <Ja************@hotmail.com> wrote in message
news:ct**********@news.seed.net.tw...

Hi,

In the MS SQL 2000 Server, if the log shipping is set up right, does that
mean data in primary server changed will mapped to secondary server later
on?
Thanks.

Jason

All changes to the source database are applied to the target database -
check out "Log Shipping" in Books Online for all the details.

Simon

Jul 23 '05 #2

johnbandettini

Jason

Another big reason to use Log Shipping for you DR/Standby solution.
Only the log shipping can update your DR/Standby database. This helps
protect the integrity of your database. If for any reason your
production and standby database do get out of synch, the log shipping
will fail, letting you know very quickly that there is a problem, so
you can fix it.

Regards

John
Simon Hayes wrote:

"Jason Huang" <Ja************@hotmail.com> wrote in message
news:ct**********@news.seed.net.tw...
Hi,

In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on?
Thanks.

Jason

All changes to the source database are applied to the target database

- check out "Log Shipping" in Books Online for all the details.

Simon

Jul 23 '05 #3

Jason Huang

Do I need to sync the time first for the Primary server and the Secondary
server? 'cuz there's some out of sync messages in the event viewer log.

<jo************@yahoo.co.uk>
???????:11**********************@f14g2000cwb.googl egroups.com...

Jason

Another big reason to use Log Shipping for you DR/Standby solution.
Only the log shipping can update your DR/Standby database. This helps
protect the integrity of your database. If for any reason your
production and standby database do get out of synch, the log shipping
will fail, letting you know very quickly that there is a problem, so
you can fix it.

Regards

John
Simon Hayes wrote:
"Jason Huang" <Ja************@hotmail.com> wrote in message
news:ct**********@news.seed.net.tw...
> Hi,
>
> In the MS SQL 2000 Server, if the log shipping is set up right, does that > mean data in primary server changed will mapped to secondary server later > on?
> Thanks.
>
> Jason
>

All changes to the source database are applied to the target database

-
check out "Log Shipping" in Books Online for all the details.

Simon

Jul 23 '05 #4

Simon Hayes

"Jason Huang" <Ja************@hotmail.com> wrote in message
news:ct**********@news.seed.net.tw...

Do I need to sync the time first for the Primary server and the Secondary
server? 'cuz there's some out of sync messages in the event viewer log.

<snip>

http://support.microsoft.com/default...b;en-us;329133

Simon

Jul 23 '05 #5

Similar topics

1384

shipping options in my cart?

by: Bruce Duncan | last post by:

first...let me aplogize if I shouldn't post this question here... I have created a few web site apps that use e-commerce technologies using ASP and XML. These are typical sites, with shipping,...

ASP / Active Server Pages

5986

Log Shipping - false alerts, real problem...

by: Tim Groulx | last post by:

Hello, I am setting up log shipping between two SQL servers. Everything in the setup seems to work fine. The problem I am having is that the "Log Shipping Alert Job - Backup" job is failing,...

Microsoft SQL Server

1697

MS SQL Server 2000 Log Shipping problem

by: InProcess | last post by:

We have successfully implemented Log Shipping between two MS SQL Server 2000 servers (bothe SP3). The problem we are having is two fold: 1) The tran log on the primary server is not being truncated...

Microsoft SQL Server

7354

How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

by: Mike | last post by:

How do I prevent SQL Server 2000 from posting successful backup completion messages to the Windows 2000 Application Event Log? I have scheduled jobs which backup my transaction logs on 50+...

Microsoft SQL Server

4077

Log Shipping Issue

by: nek | last post by:

Greetings, I tried to implement log shipping using PULL method as described in 'The Basics of DB2 Log Shipping' by Dale McInnis, but found the subsequent "rollforward" did not go beyond the...

DB2 Database

1517

Help getting data out of Outlook 2000

by: Paul H | last post by:

My customer has an ecommerce store. He receives approx 600 orders per month. Worldpay.com handles the credit card transactions and sends my customer an email for each order containing the...

Microsoft Access / VBA

2216

Question on SQL Server 2000 - 2005

by: datapro01 | last post by:

I am a DB2 DBA that has been asked to become familiar enough with SQL Server in order to become actively involved in its installation, implementation, and to review database backup/recovery...

Microsoft SQL Server

4607

Shipping Matrix Calculations

by: Chris Buckett | last post by:

Hi, I was just wondering if anyone has had any experience in developing a shipping matrix. We are based in the UK, and we need to ship both locally and internationally. Local shipping is...

C# / C Sharp

2858

Set Default Shipping Address

by: printedgoods | last post by:

Hello All! I have a shipping profile page that i created and works perfectly. User can create multiple shipping addresses that post to an access DB and they can then edit them (1 at a time). I...

ASP / Active Server Pages

7125

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7004

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7167

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

6890

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5464

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

3095

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

1423

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

657

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

292

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General