log file too big

  • how?

  • problem solved.

    sp_repldone. No need to unpublish and publish as BOL indicates.(from Microsoft)

  • In EM expand

    1. Replication Monitor

    2. then expand Publisher

    3. expand the Publishing Server Name

    4. click on the database you want

    5. from right window pane right click on the snapshot icon and click on agent property

    finally uncheck the enabled check box.

    The schedule won't work until this job is enabled again.

    MW


    MW

  • If the users can be stopped for 10 minutes, One simple solution is, detatch db and attach it back with only the .mdf file. .ldf will be created with default size of Model and you can set the max growth. This will resolve the problem

    Regards

    Fred

  • right

Viewing 5 posts - 16 through 19 (of 19 total)

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