Hi,

How to check whether a particular database has been setup for replication or not?

Be allways carefull selecting/executing the following.

1. Logon as 'sa' or with an account having 'sa_role'/'replication_role'.
2. Execute the following command to detect if the database is setup for replication.

select getdbrepstat()

If '0' the db is NOT setup for replication.
If '-2' the built-in function getdbrepstat() call failed.
etc....

For more info about repstatus etc.
just take a look for the contents/text of the sybsystemprocs..sp_reptostandby procedure.


An example : ( again be carefull )


=== Db setup to sp_reptostandby 'rep_prim_prod', 'ALL', etc...

1> use rep_prim_prod
2> go
1> select getdbrepstat()
2> go

-----------
2048

=== Db setup not replicating


1> use sybsystemdb
2> go
1> select getdbrepstat()
2> go

-----------
0


gr,

Jan

There is a much easier way:

sp_help_rep_agent <dbname>

if rep agent shows as enabled it is set up for replication



************************ Digital Solutions International - Home

Digital Solutions

We can also check which databases are getting replicated ,
I am just adding in above post :

sp_help_rep_agent null,'process'

will provide the about the rep agent which are currently running in dataserver means databases which are getting replicated in your env.

This is one extension of sp_help_rep_agent command.

Hope this helps.

cheers!