Is full-replication of *all* databases possible?

Hi All,
I am a newbie to MS SQL Server 2000 but I really need to solve this issue:
We need to daily replicate all databases within our MS SQL Server 2000 to
another MS SQL Server 2000 - the amount of databases is not fixed because
new databases are created on a daily basis.
--> Is it possible to create a job that replicates all databases from one MS
SQL Server to another and where do I have to configure it? (I already looked
at the abonnement- and replication-assistent in the enterprise manager but I
couldn't find any option to automatically daily replicate *all* databases..)
I hope somebody can help me! Any hints are highly appreciated.
cheers, jan
On Thu, 27 Oct 2005 17:26:25 +0200, "Jan Rsner" <jan.roesner@.web.de>
wrote:
>I am a newbie to MS SQL Server 2000 but I really need to solve this issue:
>We need to daily replicate all databases within our MS SQL Server 2000 to
>another MS SQL Server 2000 - the amount of databases is not fixed because
>new databases are created on a daily basis.
>--> Is it possible to create a job that replicates all databases from one MS
>SQL Server to another and where do I have to configure it? (I already looked
>at the abonnement- and replication-assistent in the enterprise manager but I
>couldn't find any option to automatically daily replicate *all* databases..)
>I hope somebody can help me! Any hints are highly appreciated.
If it's only "daily" you might just ship backups or something.
No, there's no way to automagically have a new database "replicate"
itself, some kind of setup is going to be required.
HTH,
J.