Hi all, We're running SQL 2K on Se 1

[ddrake]

Hi all,
We're running SQL 2K on Server 2K boxes (two of them - both running dual 1.4Ghz and 2Gb RAM). One of them is a primary server and the other is a backup. What I would like to do is set up logging on the primary and have those logs ship over to the backup. These boxes need to be mirror images of one another in other words. I tried the traditional publication/subscription setup, but it really bogged things down.
Can anyone point me towards the sql logging setup? Or is there a better way?

Thanks a lot!

 

[JayKusch]

Here Ya Go ....

http://www.microsoft.com/technet/tr...prodtechnol/sql/deploy/prodspecs/logship1.asp

http://www.microsoft.com/technet/tr...prodtechnol/sql/deploy/prodspecs/logship2.asp

Thanks

J. Kusch