Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    31

    Unanswered: Running out of disk space with replication

    We've got an internal database that replicates with another database server for our website.

    Not all tables are replicated, some use merge and the others are snapshot based and published regularly to the public website facing server.

    However, there's a lot of data (well, large textual data) that's being transferred and it seems to be generating massive log files that continue to grow and grow.

    I'm fairly new to adminning an SQL Server box, so was wondering if anyone can tell me what the best way to keep it under control is? I've heard its possible to truncate the logs, effectively deleting any data that has already been processed by subscribing servers etc.?

    As I said, I'm very much new to this and would really appreciate some guidance, if only to the right part of the SQL Server Books Online

    Thanks,
    Paul

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54

  3. #3
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69
    1. Change the database model to SIMPLE from FULL
    2. Schedule the database to be backed up every day.(Overwrite on the same .Bak file)

    How ever you still may loose one day worth of data if something goes terribly wrong between the daily back ups.

    masanam.

Posting Permissions

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