Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Red face Unanswered: Error on replication

    Hi,
    when i try to run an push-replication on MS SQL 2000
    i get the error "Log file is full" on the subscriber.
    I tried to make this grow VERY much, but it doesnt help.
    The table that fails has over 75000 posts, so maybe that is an issue.

    The error occurs when i for the first time tries to sync it...

    Any ideas?

    // Peter

  2. #2
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    Try breaking your task into smaller units of work.

    You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.

    Good Luck,
    Bruce Baasch

  3. #3
    Join Date
    Nov 2002
    Posts
    2
    Well, the thing is... i only want to replicate this to a server, and not
    run any scripts. Shouldnt MS-SQL handle this?

    I tried the push-operation without the LARGE-table (75000 posts)
    and it worked. So it has something to do with that.
    Any more suggestions?

    Please?!!

    // Peter

    Originally posted by Bruce A. Baasch
    Try breaking your task into smaller units of work.

    You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.

    Good Luck,

Posting Permissions

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