SQL Server 2000 Replication Problem

Posted on 2006-05-05
Last Modified: 2011-10-03
I have two SQL Server 2000 installations, on two different servers.  The database currently exists on SERVER1 which is the AD controller for the domain.  I'm attempting to have this database replicate to the server BACKUP1 which is a member server in this same domain.

I setup the SERVER1 as a Publisher/distributor and configured the database to replicate.  I created a subscription to the other computer.  

I'm getting the error messages:

Error Message:

The process could not access database 'MyDatabase' on server 'BACKUP'.

Error Detals:

Could not locate entry in sysdatabases for database 'MyDatabase'. No entry found with that name. Make sure that the name is entered correctly.
(Source: BACKUP (Data source); Error number: 911)

Obviously SERVER1 is having difficulty replicating to BACKUP but I'm not sure how to resolve this.

Question by:jhance
    LVL 33

    Accepted Solution

    Assuming that your source objects on SERVER1 are in a database called MyDatabase, then you would do well to create an empty database by the same name on BACKUP1 before you push the subscription.  This will allow you to set the initial size of the data and log files appropriately.

    Then right-click on the Distributor Agent and select Properties.  Then make sure the "owner" has sufficient rights to push the data to the subscriber.  (You may wish to create a separate login just for this purpose).
    LVL 28

    Expert Comment

    make sure your subscriber database exists not nessesary to be the same name as the database on server1 and the sql server agent on both the server (server1 and backup1)  should run under same user name.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now