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

    Unanswered: Log file growing in amazing manner

    I started my database in last week to user with transfer data from Sybase to sql 2000 server. Intitally log file size was few MB near to 20 MB for each cos, within 8 days it has reached upto 300 MB still datafile size in few MB , approximately 40MB for each cos, why log file growing in such manger, how I can manage it?

    Thanking You


  2. #2
    Join Date
    Nov 2002
    Are you performing any database maintenance?

    How did you "transfer" the data from sybase?

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    You need to control the transaction size in your load. Doesn't matter what tool you use (unless you have a linked server and doing INSERT...SELECT FROM) you can specify the number of rows to be viewed as 1 transaction. This option is available in DTS, BCP, and BULK INSERT utilities (DTS uses a combination of those)
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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