Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Unanswered: Restore and update problem on Windows

    Hi,
    I have restored a database from a BAK file and tried to run a update query.
    While executing the query , i got this error.

    Server: Msg 208, Level 16, State 1, Procedure ctsv_992F1918D5FC11D4968C0090271F4533, Line 2
    Invalid object name 'MSmerge_contents'.

    What can be the possible reasons for the error?
    Suggest the solutions if any.
    Prashant

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Which version of sql server are you using ? Are you using merge replication ?

  3. #3
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,
    I am using the MS SQL Server 2000.
    About merge replication, i am not aware of this as i am a new user. More over we are restoring the backup that we have, from the restored database we can see all this views and procedures which are used for merge replication.
    How can we check that we are using merge replication?

    Regards,
    Prashant

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Look under enterprise manager - go to the replication folder - look at publications or subscriptions and you should see entries.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Are you restoring onto the same sql server instance ? Are you only restoring a particular database ?

  6. #6
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,
    There are no entries in the Publications and Subscriptions folder.
    We are restoring a particular backup that we got from our client.
    Prashant

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    Are you saying then that this is not a backup of the current machine you are working with - it was a backup of another sql server machine ? Or are you restoring on the clients machine ?

  8. #8
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,
    Yes , you guessed that correctly.
    It's a backup from some other machine (client's db backup) and we are restoring it on our machine for fixing few things.
    This original database is not with us and we do not have details of his machine either. We only have the .BAK file.
    Prashant

  9. #9
    Join Date
    Feb 2002
    Posts
    2,232
    Without that information, you are running in the fog. My only recommendation is to try and run sp_mergecleanupmetadata - make sure you read the bol about this stored procedure. The only problem is that you have no replication so this stored procedure may be of no use. Let me know if you have any success with this.

    When you say you are fixing a few things - will these fixes go back to the client ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •