Is Replication of entire server possible?

I have 1 sql 2000 server in place that has about 150 databases on it. Two
applications work access those databases half are for one application half
are for the other application. Since the server is becoming quite
overloaded lately I've decided to take another server with sql 2000 on it
and split one application off of the original server and place it's
databases on the second effectively splitting the load between two servers.
Now I'd like to use replication to have both servers be almost identical to
give me some redundency in the hardware. Can I easily set up replication so
that server 1 and server 2 both contain the same databases and the data is
replicated between the two? I know I can go in and set up a merge
replication for each DB and this will work ( I've done this with 2 db's
already) but can I set it so that the server figures out what DB's there
are and replicates them? This will allow me to not need to take the time
to setup more replication at the time of a new DB's creation.Nope, it's manual.
I'd think hard about the manageability of a replication setup with 150
database. There are other ways to split the load while providing redundancy.
For example, you could setup a multi-instance failover cluster and make sure
you mirror the disks (always a good practice anyway). Slightly higher cost
in initial hardware purchase but IMHO, much less pain (consequently; lower
cost) in the long run.
joe.
"jamie" <strider3700@.nospam.nospam> wrote in message
news:%232hnndn3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>I have 1 sql 2000 server in place that has about 150 databases on it. Two
>applications work access those databases half are for one application half
>are for the other application. Since the server is becoming quite
>overloaded lately I've decided to take another server with sql 2000 on it
>and split one application off of the original server and place it's
>databases on the second effectively splitting the load between two servers.
> Now I'd like to use replication to have both servers be almost identical
> to give me some redundency in the hardware. Can I easily set up
> replication so that server 1 and server 2 both contain the same databases
> and the data is replicated between the two? I know I can go in and set
> up a merge replication for each DB and this will work ( I've done this
> with 2 db's already) but can I set it so that the server figures out what
> DB's there are and replicates them? This will allow me to not need to
> take the time to setup more replication at the time of a new DB's
> creation.
>|||clustering would require stepping up to sql 200 enterprise edition would it
not? I'm stuck with two copies of standard addition making all the fun
tools a little out of reach it feels like.
the original server has a good raid system mirroring disks but the issue is
the OS is starting to get a little flakey after 3 years of hard use. A
complete second box to keep us running even if I manually have to tell
everyone to use the other box is the only thing that would keep me
comfortable.
"Joe Yong" <NO_jyong_SPAM@.scalabilityexperts.com> wrote in message
news:u0G4Jhp3FHA.3600@.TK2MSFTNGP12.phx.gbl...
> Nope, it's manual.
> I'd think hard about the manageability of a replication setup with 150
> database. There are other ways to split the load while providing
> redundancy. For example, you could setup a multi-instance failover cluster
> and make sure you mirror the disks (always a good practice anyway).
> Slightly higher cost in initial hardware purchase but IMHO, much less pain
> (consequently; lower cost) in the long run.
>
> joe.
> "jamie" <strider3700@.nospam.nospam> wrote in message
> news:%232hnndn3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>|||Hello,
SQL Standard Edition doesn't support cluster:
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_ts_8dbn.asp
However, you may do it by using SQLDMO for replication. Here are scripts
for transactional with vb.net and SQL DMO.
<http://www.replicationanswers.com/Script1.asp>
<http://www.replicationanswers.com/Script2.asp>
Here are some scripts to achieve similar ends using the ActiveX controls in
C# for transactional and merge.
<http://support.microsoft.com/defaul...kb;EN-US;319649>
<http://support.microsoft.com/defaul...kb;EN-US;319646>
Note: This response contains a reference to a third party World Wide Web
site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - 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.