Post reply

Replicating Databases between servers

  • May 30, 2011 at 4:35 pm

    #237182

    Hi all,

    I have followed a guide on this site and setup replication between 2 - 2008 R2 Standard Sql Databases.

    The replication is working correctly and I get no errors.

    The issue I have though is that when I run the application that used the database it says that it is not a valid database for the application.

    The application we are using is called Finpower, I have talked to the support people from there but they are not sure either.

    I selected everything that was possible when setting up the replication which was tables and views.

    I also copied the entire database over to the 2nd replication server and set it up before doing the replication. I tested the Finpower application after copying over the database and it ran ok.

    After doing the replication though, it errors with the message that the database is not valid.

    I noticed that the original database is bigger than the replicated one. The original database is about 2.5 gig and the replicated one is about 1.8 gig.

    I do not know why they would be different sizes.

    Can anyone shed any light on why this is happening, I have been trying to get this sorted now for some time but unable to find an answer.

    Any help would be appreciated.

  • May 30, 2011 at 5:04 pm

    #1331751

    Run a trace when the application connects, see what is happening and check the same code on the main server, perhaps something is missing.

  • May 30, 2011 at 6:04 pm

    #1331756

    Hi and thanks for the reply,

    I agree that something may be missing.

    When you say run a trace when you start the application, is this something I do through the sql server, just not sure how to do this ?

  • May 30, 2011 at 7:00 pm

    #1331763

    If you've never done it, use the Profiler utility to connect to the server and start a basic trace (File New) against the server. This will tell you what commands are being submitted to the server.

  • May 30, 2011 at 7:36 pm

    #1331766

    Hi I ran the profiler and it shows the following image,

    can you see anything wrong here ?

  • May 31, 2011 at 7:27 am

    #1331969

    Bump,

    Hi just wanted to bump this back to the top to see if any of your experts can offer any more advice, hope this is all right.

    I am getting a bit desperate to find an answer and any help would be appreciated

  • May 31, 2011 at 9:14 am

    #1332051

    there isn't anything wrong with what you see, nor will there be from our perspective. What you need to do is take these comments and run them against both servers from SSMS or a query window and compare the results:

    exec xp_msver 'ProductVersion'

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply