replication of sql server within a WIndows 2003 cluster

We have two server setup in a Windows 2003 cluster with SQL 2005 loaded on
both servers. A database was loaded on one server and and we noticed that the
database seem to replicate over to the ohter sql server without a database.
Since then the database on server 2(active) has grown in size and the
database on server1(passive)has remained the original size.
Should i setup relicaion or another options so that the databases are both
showing the same size files?
I'm not sure if I understand your question. By default in an active/passive
(single instance) topology, upon failover all databases will be transferred
to the second node. If by chance you are talking about an active/active
(multi-instance) topology, you need replication installed and configured to
replicate. Drill down on the replication folder for local publications to
see if there is a publication for your database.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"toma" <toma@.discussions.microsoft.com> wrote in message
news:556CE8FF-45BD-462D-9FF9-0C838C4A864F@.microsoft.com...
> We have two server setup in a Windows 2003 cluster with SQL 2005 loaded on
> both servers. A database was loaded on one server and and we noticed that
> the
> database seem to replicate over to the ohter sql server without a
> database.
> Since then the database on server 2(active) has grown in size and the
> database on server1(passive)has remained the original size.
> Should i setup relicaion or another options so that the databases are both
> showing the same size files?
|||Thank you for your response.
we have an active/passive enviroment for failover.
server1 is passive and server2 is active.
The database on server2(active) is 35mbytes. The same file on the
server1(passive) is 19 mbytes.
I am concerned that when server2 fails over to server1 that some of the
database functionality will be lost since the files are of different size.
Do you know if the larger database file on the active server will be copied
to the passive server or should I run replicator to insure that the databse
files are the same on each server?
"Hilary Cotter" wrote:

> I'm not sure if I understand your question. By default in an active/passive
> (single instance) topology, upon failover all databases will be transferred
> to the second node. If by chance you are talking about an active/active
> (multi-instance) topology, you need replication installed and configured to
> replicate. Drill down on the replication folder for local publications to
> see if there is a publication for your database.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "toma" <toma@.discussions.microsoft.com> wrote in message
> news:556CE8FF-45BD-462D-9FF9-0C838C4A864F@.microsoft.com...
>
>