Re: SQL Server License Question

Tech-Archive recommends: Fix windows errors by optimizing your registry



--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


....
(1) Investigate database mirroring.
JP: To what end?
for Database redundencty and disaster recovery.
Is Mirroring a form of clustering, or ?

Yes, Database Mirroring is a from of Clustering, available with SQL 2005


(2) Investigate log shipping.
JP: The datebase design will not support log shipping
And how is that?
It's my understanding that rows need a datetimestamp or similar to know
what
data is updated, this database has it's own logs and sync engine for
syncing
w/in the application.

No, that is not true. With Log Shipping, you first create a copy of the
production database (using a 'snapshot' copy), and then use the 'regular'
database logs. The process sends copies to the 'Hot standby' server, applies
them, and stands ready.. If you are using FULL Logged Mode (which I
certainly hope you are on a production server), then Log shipping may be a
relatively painless way to keep two servers syncronized.


Perhaps I was bit quick to judgement, I have an associate who, if any form
of
replication was doable, would have done so, he ended up doing a complete
overwrite each day, and it was very time and bandwidth consuming.


For some folks, the whole Replication idea is boggling to master...


(3) Investigate database replication.

JP: The only form of replication is complete overwrite copy, and we
already have
bandwidith issues, due to intense virus scanning that is not negociable
with
IT/Mgt.
Transactional Replication may work...


Transactional Replication also uses the database logs to keep track about
what data needs to be sent to the replicant. Again, a snapshot is taken at
the beginning, and then every time there is a data action (IUD), it is
written to the log. The replication agent picks up that change, stores it in
a replication (publisher) database, and then sends only the changes to the
replicant on schedule. Transactional Replication is preferred to Log
Shipping when the replicant is also 'on-line'.


No one that I know of has been able to make this work with this
application's
database.


Now you can make your mark. It may not be 'slam-dunk' easy, but either Log
Shipping or Transational Replication should work for you.


We have 25 CAL's and one SQL server, however I'd like to add another
Server as
an emergency system that will do other processes but also be
available
to
be the
replacement if the primary server should be permanently unavailable.

You will need to license the second SQL Server, unless you install it
as
a
cluster node in an active/passive 2-node cluster.

JP: Can a cluster server become the primary server in case of a
disaster?
in Active/Passive clusters, the Passive node takes over and becomes the
Active node when the original 'active' node fails.

We have Std Server 2000 and 2003, it appears that clustering isn't
available
with that edition.


And that also leaves out Log Shipping.

--
Lawrence Garvin, M.S., MVP-Software Distribution
Everything you need for WSUS is at


http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx
And, eveything else is at
http://wsusinfo.onsitechsolutions.com
...





Thanks to all who posted.... JeffP...




.

Relevant Pages

  • Re: Publishers disappeared from under replication monitor
    ... Basically the only database on the server being replicated suddenly had 'no' ... This seemed like some kind of corruption in the database. ... The next day we set up transactional replication again (Yes, ... > distribution agent name you can get a condition like this. ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication with failover clustering??
    ... We are having Merge Replication setup with push subscription. ... Microsoft SQL Server clustering is not a good fit for geospatial clustering ... Both clustering and database mirroring do do automatic failover, ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)