A Guide to SQL Server 2000 Transactional and Snapshot Replication

Installing Replication

Let me live like a sky rocket. Let me colour the night sky for a single

instant, burning with all of my being. And then burn out.

— Yukio Mishima

This chapter focuses on installing replication on your SQL Server.Most

users will only install replication on their SQL Server and then enable

Subscribers.We’ll look at these two options and then look at how to set up

your SQL Server to use a remote Distributor. After looking at these

options, we’ll look at Replication Monitor, which is the central point for

replication administration. In the process we’ll cover some of the more

advanced options and settings. Following that, for those of you who are

wizard adverse, we will look at the replication stored procedures that you

can use to carry out the same things.

There are really two parts to installing replication:

• Configuring your SQL Server as a Publisher/Distributor or a Distributor

• Configuring your Subscribers

Recall from Chapter 1 that a Distributor is a SQL Server that stores and

distributes transactions from your Publisher to your Subscriber. For most

replication solutions, your Publisher and Distributor will be on the same

server. For high throughput replication solutions, you should look at using

a remote Distributor.

Configuring your SQL Server as a Distributor

Configuring your SQL Server as a Distributor involves running a wizard

that creates a distribution database and several jobs in the msdb database.

After your distribution database is installed, you are ready to create your

publications. Let us walk through the wizards to understand how to configure

your server as a Distributor. The first time you configure your SQL

Server as a Distributor, open up Enterprise Manager (EM), connect to your

SQL server, and on the Tools menu, point to Replication, and then click

Configure Publishing, Subscribers, and Distributors (Fig. 2.1). You can

bypass this altogether and merely click Create and Manage Publications,

which is what most DBAs do. Read more

Comment on "A Guide to SQL Server 2000 Transactional and Snapshot Replication"

Home Site Map Advertise For Sale Subscribe to our Monthly Email Newsletter	Not While the Surf's Up Press A Guide to SQL Server 2000 Transactional and Snapshot Replication Installing Replication Let me live like a sky rocket. Let me colour the night sky for a single instant, burning with all of my being. And then burn out. — Yukio Mishima This chapter focuses on installing replication on your SQL Server.Most users will only install replication on their SQL Server and then enable Subscribers.We’ll look at these two options and then look at how to set up your SQL Server to use a remote Distributor. After looking at these options, we’ll look at Replication Monitor, which is the central point for replication administration. In the process we’ll cover some of the more advanced options and settings. Following that, for those of you who are wizard adverse, we will look at the replication stored procedures that you can use to carry out the same things. There are really two parts to installing replication: • Configuring your SQL Server as a Publisher/Distributor or a Distributor • Configuring your Subscribers Recall from Chapter 1 that a Distributor is a SQL Server that stores and distributes transactions from your Publisher to your Subscriber. For most replication solutions, your Publisher and Distributor will be on the same server. For high throughput replication solutions, you should look at using a remote Distributor. Configuring your SQL Server as a Distributor Configuring your SQL Server as a Distributor involves running a wizard that creates a distribution database and several jobs in the msdb database. After your distribution database is installed, you are ready to create your publications. Let us walk through the wizards to understand how to configure your server as a Distributor. The first time you configure your SQL Server as a Distributor, open up Enterprise Manager (EM), connect to your SQL server, and on the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distributors (Fig. 2.1). You can bypass this altogether and merely click Create and Manage Publications, which is what most DBAs do. Read more Rate This Article: Comment on "A Guide to SQL Server 2000 Transactional and Snapshot Replication" Your Name Your Comments Verification Code: A1735 Enter Code: A Guide to SQL Server 2000 Transactional and Snapshot Replication This chapter focuses on installing replication on your SQL Server.Most users will only install replication on their SQL Server and then enable Subscribers.We’ll look at these two options and then look at how to set up your SQL Server to use a remote Distributor. After looking at these options, we’ll look at Replication Monitor, which is the central point for replication administration. In the process we’ll cover some of the more advanced options and settings. Following that, for those of you who are wizard adverse, we will look at the replication stored procedures that you can use to carry out the same things. TITLES A Guide to SQL Server 2000 Transactional and Snapshot Replication Oracle Awards Letter of Supply to Mythics for Oracle Exadata Platform VIRGINIA BEACH, Va., Aug. 31 /PRNewswire/ -- Mythics an award winning Oracle PartnerNetwork Platinum Partner in the Oracle PartnerNetwork, Oracle GSA Schedule Holder (GS-35F-0153M) and IT solutions provider, today announced that it has a letter of supply to resell the Oracle Exadata platform from Oracle. After IBM dalliance, Sun goes to Oracle for $7.4B Sun Microsystems Inc.'s scramble to find a suitor landed the slumping server and software maker in the arms of Oracle Corp., which agreed to pay $7.4 billion in cash for Sun in a startling marriage that would transform Silicon Valley and the computing industry. Publisher Announces Long-term Support for Oracle Technologies Packt Publishing has today unveiled ambitious plans to improve its support for Oracle documentation by announcing a long-term commitment to publishing in the area. MS SQL Server Versions The latest version of SQL Server is Microsoft SQL Server 2005, this was released on 7th November 2005, at the time of writing this article I do not know of many organisations that are utilising SQL Server 2005 in a production environment but many organisations that utilise Microsoft SQL Server as a database solution have SQL Server 2005 setup in a test environment and have plans to migrate their production environments to this latest version in the future. DAZ Systems, Inc. Opens New Office on East Coast DAZ Systems, Inc. an Oracle Certified Advantage Partner, providing Oracle E-Business Suite implementation and integration services, today announced the expansion of its offices on the East Coast. TimeLink Achieves Oracle Validated Integration with Oracle’s PeopleSoft Enterprise Time and Labor 9.1 TimeLink, a premier provider of enterprise workforce management (EWM) and data collection solutions has announced that it has achieved Oracle ® Validated Integration of TimeLink Direct 5.2 with Oracle’s PeopleSoft Enterprise Time and Labor 9.1. Clean Energy Company Carmanah Technologies Goes Live on Oracle in 16 Weeks Carmanah has been putting solar to work since 1996. The first company of its kind in the world, Carmanah pioneered the self-contained solar light and continues to develop best-in-class solar LED lighting and solar power systems for industrial applications worldwide. MiPro Consulting Achieves Oracle PartnerNetwork Certified Advantage Partner Status MiPro Consulting joins elite group of companies focused on Oracle's PeopleSoft Enterprise, Oracle Business Intelligence Enterprise Edition and Oracle Business Intelligence Applications who have achieved Certified Advantage Partner status within the Oracle PartnerNetwork. Idera Announces Second Segment of Educational Webcast Series For SQL Server Developers Idera announced the second segment in the “Secrets of SQL Server” webcast series titled “Exploring SQL Server 2008 R2 Reporting Services.” SQL Server developers and database administrators (DBAs) will learn how to get the most from reports using the latest release of SQL Server 2008. The event takes place Wednesday, April 14, 2010 at 3 p.m. CT, and is hosted by Donabel Santos, a SQL DBA, developer and trainer at Black Ninja Software and an instructor at the British Columbia Institute of Technology. Idera Webcast Demonstrates How to Best Use SQL Server Dynamic Management Views Expert Greg Robidoux Shows How DMVs Can Improve SQL Server Management How to Recover/Reset SA Password or Other MS SQL Passwords? A few days ago, I had a painful experience that I lost SA password on my MS SQL Server database, and I almost took the whole weekend to look for an efficient way to reset SA password. I asked friends, searched on Internet and even bought some books…. Fortunately, I finally got a SQL Password Recovery software and it instantly reseted SA password without data loss. And I also got a couple of good “reset SA password” solutions to save your weekend in case you have lost or forgot MS SQL Server passwords (SA password!) xSQL Software's RSS Reporter for SQL Server Makes Job Monitoring Easy xSQL Software releases an innovative new tool for SQL Server database administrators, the RSS Reporter for SQL Server 2005 and SQL Server 2000. No more cluttering your mailbox with hundreds of SQL Server notifications, no more digging through those emails to get the information you need, no more missed important notifications… You can now, in minutes, generate standard RSS feeds that contain all the information you need for monitoring SQL Server jobs running on multiple servers - clean, simple, and standard. SQL Server Clustering - SQL Server Mirroring solution Have you ever felt the need to have redundancy or maybe even a failover solution for your SQL Server database?