Home Forums SQL Server 2005 SS2K5 Replication SQL database not accessible during transactional replication RE: SQL database not accessible during transactional replication

  • In our situation replication doesn't run continuously. It's scheduled for the night and it runs a few times a week. To my opinion that's better because also the data in the publisher is updated only a few times every week.

    And yes you're right, SQL server is working and some data can be retrieved from the tables. But in most cases it takes a very long time for (some relatively simple) stored procedures to run. This will end up with a timeout error on the website.

    I hope the problem is a bit more clear now.