Recent content by samuraiRocker

Hi. We have three separate web servers being load-balanced, and I have an ASP script on each of those machines to log user hits. All of the three machines have an ODBC connection to another database server which runs SQL Server 2000. The problem is, when user visits the page, it looks like...

Ashely, I tried setting it up again and now it works perfectly. Thank you very much for your help. It seems, though, that distributor also updates the record in the publisher, and this seemed faster than publisher updating the distributor's data..... I'm sort of confused because I never...

Ashley, Thanks again for your message. When you say 'create a subscription in the target server', do you mean I should 'Pull' subscription from the publisher instead of 'Push'-ing the subscription to the distributor??

Ashley, Thanks for your comment. I have tried all day yesterday trying to set up the Transactional Replication, but I'm not sure if it's working correctly. I have configured Distributor/Publisher and I 'Push'-ed subscription to the Distributor DB, and that went fine, it seems. However, I...

Hi. I need to have two separate database servers to have the same exact data at all times, and I'm guessing "mirroring" the SQL Server would somehow achieve this, but I'm not sure if that's the best way, or if it's possible at all. We are trying to have two different servers acting...

Thank you all for your replies. tlbroadbent, thanks for the detailed explanation. But I'm not sure how I can incorporate that as part of a maintenace plan.....is there a way to do that?? Bernadette, wouldn't there be a shortcoming by unchecking that option? To be honest, I'm not sure how...

Hi. I've been getting an error message for one of my database maintenance plans. When it tries to check integrity/indexes as part of the maintenance, it fails saying that the database has to be in the single-user mode. It wouldn't be much of a problem if this was a one time deal, but since...