Results 1 to 6 of 6

Thread: Snapshot error

  1. #1
    Join Date
    Jul 2003
    Posts
    16

    Unhappy Unanswered: Snapshot error

    Hi,

    We used to have a replication running and after some time it failed.
    The subscriber database had received some new tables and stored procedures (The articles that we are publishing are only tables).
    According to my developers none of the replicated tables were changed, only the stored procedures.

    But I got this error, when running the snapshot agent:

    The process could not bulk copy out of table '[dbo].[syncobj_0x4343434530463743]'.

    Anybody knows why?

    Thanks a lot.
    Felicia Schimidt

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Drop and recreate your replication.

  3. #3
    Join Date
    Jul 2003
    Posts
    16
    Originally posted by rdjabarov
    Drop and recreate your replication.

    I already done that but I got the same error!

  4. #4
    Join Date
    Jul 2003
    Posts
    16
    Originally posted by fschimidt
    I have already done that but I got the same error!
    The full message I got is:
    Could not open FCB for invalid file ID 23144 in database '....

    Any ideas??

    Thanks!

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    OK, now you're talking! First of all, run DBCC CHECKDB and see if yu get any errors there (last couple of lines, as well as any red messages).

    If errors are found (which I know they will be):

    - Backup your database
    - change to MASTER, sp_dboption 'your_database_name', 'single', true
    - if failes to set to SINGLE USER, - kill connections and run sp_dboption again
    - run DBCC CHECKDB('your_db_name', REPAIR_ALLOW_DATA_LOSS) and confirm that all found errors are repaired
    - re-run DBCC CHECKDB('your_db_name') and make sure no errors are found

  6. #6
    Join Date
    Jul 2003
    Posts
    16

    Talking

    Originally posted by rdjabarov
    OK, now you're talking! First of all, run DBCC CHECKDB and see if yu get any errors there (last couple of lines, as well as any red messages).

    If errors are found (which I know they will be):

    - Backup your database
    - change to MASTER, sp_dboption 'your_database_name', 'single', true
    - if failes to set to SINGLE USER, - kill connections and run sp_dboption again
    - run DBCC CHECKDB('your_db_name', REPAIR_ALLOW_DATA_LOSS) and confirm that all found errors are repaired
    - re-run DBCC CHECKDB('your_db_name') and make sure no errors are found

    YES!
    I follow all the steps and it worked!
    I recreated the replication and I got no more errors!

    Thanks a lot!
    Felicia

Posting Permissions

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