Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Red face Unanswered: Empty Log files and Data files

    I'm using replication with two database on SQL 2000,when begin, the log files size is 50mb and the data files size is 150mb. But now the log files size is 2Gb and the data files size is 4Gb. I would like to decrease the log files and the data files ??? How do i do this???
    (I using Truncate and shrink doesn't change )

  2. #2
    Join Date
    Mar 2004
    For log file, after replicating, take a full backup of your database, then truncate log.. This must reduce the log file..

    I have no other idea about reducing the data file size.


  3. #3
    Join Date
    Oct 2001
    Is this on the source, destination or distribution?
    Backup the log or change the recovery model to simple then shrink the log.

    For data - shrink the data file.

    Are you sure that the data is replicating and it's not building up because transactions can't be cleared?
    That would end up with a lot of data in the distribution database and log space used.

Posting Permissions

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