Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    68

    Unanswered: LOG FILE ISSUE - NewBie

    I have some Log files that are getting extremely large as I teach myself the importing/Exporting/Tranformation 's and such. I need to shrink the Log file to a manageable size. The data file is 16gig and the log file is 16gig. Help..
    jm

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    dbcc shrinkfile(...) Look it up in BOL
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Consider also:

    1. Backup the database and then make log file backups. Run a log file backup after doing an import.

    2. Or, set your recovery model to SIMPLE (SQL 2000) or Trunc. Log on Checkpoint (SQL 7).

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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