randyv

Hello -

I'm relatively new to SQL Server, but am a Certified
Teradata Master. The company I work for runs an online
store (ASP, ASP.NET applications) on an SQL Cluster. The
OS on the cluster is W2kAS. The SQL Server is SQL Server
2000 EE. (This is the production server)

We want to maintain a backup. At the present time the
only server I have available to accomplish this is one
with a WXP Pro OS and an instance of SQL Server 2000
Personal Edition. (This is the backup server)

My understanding is EE is required to do log shipping, so
that appears out.

I was considering linking the production server to the
backup server and doing distributed queries, but the
overhead considerations appear to rule that out. (it was
just recommended not to do this in the do***entation I
read, but if it is viable, I'd like to know.)

Is it possible to set up replication between the
production server and the backup server given the above
configurations? Are there any gotchas, or is this
just 'straightforward' setting up database replication?

I appreciate any advice from those more experienced in
SQL Server than I.

Thanks very much in advance.

randyv

petery

Hello Randy,

Thank you for your posting.

From your post I understand that you want to set up replication between the
production SQL cluseter server and a Personal Edition backup on WinXP Pro.

From "Features Supported by the Editions of SQL Server 2000" in Book
Online, Personal Edtion supports the same replication level as MSDE.

Personal Edition and MSDE can act as both a Publisher or Distributor, and a
Subscriber, and it can replicate between Personal or MSDE versions and
regular versions of SQL Server. Additionally, you cannot use it for
transactional publication, but you can use it as a Publisher of snapshot
replication, and merge replication, and as a Subscriber to all three types
of publications.

I suggest that you refer to the following articles for more detailed
information:

324992.KB.EN-US HOW TO: Use Replication with SQL Server 2000 Desktop Engine
(MSDE 2000)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;324992

http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp

The log shipping feature is only available in Enterprise Edition.
Therefore you are not able to use Personal Edition or MSDE to run log
shipping.

If you have further questions on the issue, please feel free to post back.

Thanks & Regards,

Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support

Get Secure! - http://www.microsoft.com/security

================================================== ===
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.


--------------------
| Content-Class: urn:content-classes:message
| From: "randyv" <randy.volters@whaleyfoodservice.com>
| Sender: "randyv" <randy.volters@whaleyfoodservice.com>
| Subject: looking for advice on approach, etc.
| Date: Mon, 14 Jul 2003 09:45:49 -0700
| Lines: 33
| Message-ID: <071101c34a27$61215420$a001280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNKJ2EhwpapctlVSd+pxvCr0E/60g==
| Newsgroups: microsoft.public.sqlserver.replication
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:41455
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Hello -
|
| I'm relatively new to SQL Server, but am a Certified
| Teradata Master. The company I work for runs an online
| store (ASP, ASP.NET applications) on an SQL Cluster. The
| OS on the cluster is W2kAS. The SQL Server is SQL Server
| 2000 EE. (This is the production server)
|
| We want to maintain a backup. At the present time the
| only server I have available to accomplish this is one
| with a WXP Pro OS and an instance of SQL Server 2000
| Personal Edition. (This is the backup server)
|
| My understanding is EE is required to do log shipping, so
| that appears out.
|
| I was considering linking the production server to the
| backup server and doing distributed queries, but the
| overhead considerations appear to rule that out. (it was
| just recommended not to do this in the do***entation I
| read, but if it is viable, I'd like to know.)
|
| Is it possible to set up replication between the
| production server and the backup server given the above
| configurations? Are there any gotchas, or is this
| just 'straightforward' setting up database replication?
|
| I appreciate any advice from those more experienced in
| SQL Server than I.
|
| Thanks very much in advance.
|
| randyv
|

petery

Hello Randy,

As per your questions on linking the production server to the backup server
and doing distributed queries, there is a concurrent workload governor that
may keep the Server from exploiting machine resources to their maximum
which is why this may not be a viable solution.

Here is some info from BOL on concurrent workload governor:

A concurrent workload governor limits the performance of the database
engine in these two editions (Personal and Desktop). The performance of
individual Transact-SQL batches is decreased when more than five batches
are executed concurrently. The amount each batch is slowed down depends on
how many batches over the
five-batch limit are executing concurrently, and the amount of data
retrieved by the individual batches. As more batches are executed
concurrently, and as more data is retrieved by each batch, the more the
governor slows down the individual batches. You can use the DBCC
CONCURRENCYVIOLATION statement to report how often the concurrent workload
governor is activated. For more information, see DBCC CONCURRENCYVIOLATION.

Please feel free to post back if you have further questions regarding this
issue.

Thanks & Regards,

Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support

Get Secure! - http://www.microsoft.com/security

================================================== ===
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.


--------------------
| X-Tomcat-ID: 136041295
| References: <071101c34a27$61215420$a001280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: petery@online.microsoft.com (Peter Yang [MSFT])
| Organization: Microsoft
| Date: Tue, 15 Jul 2003 06:18:15 GMT
| Subject: RE: looking for advice on approach, etc.
| X-Tomcat-NG: microsoft.public.sqlserver.replication
| Message-ID: <dx2BAkpSDHA.2808@cpmsftngxa06.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.replication
| Lines: 98
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:41475
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hello Randy,
|
| Thank you for your posting.
|
| From your post I understand that you want to set up replication between
the
| production SQL cluseter server and a Personal Edition backup on WinXP
Pro.
|
| From "Features Supported by the Editions of SQL Server 2000" in Book
| Online, Personal Edtion supports the same replication level as MSDE.
|
| Personal Edition and MSDE can act as both a Publisher or Distributor, and
a
| Subscriber, and it can replicate between Personal or MSDE versions and
| regular versions of SQL Server. Additionally, you cannot use it for
| transactional publication, but you can use it as a Publisher of snapshot
| replication, and merge replication, and as a Subscriber to all three
types
| of publications.
|
| I suggest that you refer to the following articles for more detailed
| information:
|
| 324992.KB.EN-US HOW TO: Use Replication with SQL Server 2000 Desktop
Engine
| (MSDE 2000)
| http://support.microsoft.com/default.aspx?scid=KB;EN-US;324992
|
| http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
|
| The log shipping feature is only available in Enterprise Edition.
| Therefore you are not able to use Personal Edition or MSDE to run log
| shipping.
|
| If you have further questions on the issue, please feel free to post
back.
|
| Thanks & Regards,
|
| Peter Yang
| MCSE2000, MCSA, MCDBA
| Microsoft Partner Online Support
|
| Get Secure! - http://www.microsoft.com/security
|
| ================================================== ===
| 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.
|
|
| --------------------
| | Content-Class: urn:content-classes:message
| | From: "randyv" <randy.volters@whaleyfoodservice.com>
| | Sender: "randyv" <randy.volters@whaleyfoodservice.com>
| | Subject: looking for advice on approach, etc.
| | Date: Mon, 14 Jul 2003 09:45:49 -0700
| | Lines: 33
| | Message-ID: <071101c34a27$61215420$a001280a@phx.gbl>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="iso-8859-1"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| | Thread-Index: AcNKJ2EhwpapctlVSd+pxvCr0E/60g==
| | Newsgroups: microsoft.public.sqlserver.replication
| | Path: cpmsftngxa06.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:41455
| | NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| | X-Tomcat-NG: microsoft.public.sqlserver.replication
| |
| | Hello -
| |
| | I'm relatively new to SQL Server, but am a Certified
| | Teradata Master. The company I work for runs an online
| | store (ASP, ASP.NET applications) on an SQL Cluster. The
| | OS on the cluster is W2kAS. The SQL Server is SQL Server
| | 2000 EE. (This is the production server)
| |
| | We want to maintain a backup. At the present time the
| | only server I have available to accomplish this is one
| | with a WXP Pro OS and an instance of SQL Server 2000
| | Personal Edition. (This is the backup server)
| |
| | My understanding is EE is required to do log shipping, so
| | that appears out.
| |
| | I was considering linking the production server to the
| | backup server and doing distributed queries, but the
| | overhead considerations appear to rule that out. (it was
| | just recommended not to do this in the do***entation I
| | read, but if it is viable, I'd like to know.)
| |
| | Is it possible to set up replication between the
| | production server and the backup server given the above
| | configurations? Are there any gotchas, or is this
| | just 'straightforward' setting up database replication?
| |
| | I appreciate any advice from those more experienced in
| | SQL Server than I.
| |
| | Thanks very much in advance.
| |
| | randyv
| |
|
|