dcsimg
Results 1 to 2 of 2

Thread: Event ID 17052, Error: 9002, 17:2 SQL 7.0

  1. #1
    Join Date
    Apr 2003
    Location
    Charlotte, NC
    Posts
    1

    Unhappy Event ID 17052, Error: 9002, 17:2 SQL 7.0

    I am receiving the following error and do not know how to correct this. Please help!

    Event ID: 17052
    Error: 9002
    Severity: 17
    State: 2
    The log file for database ' ' is full. Back up the transaction log for the database to free up some log space.

    The problem is that someone before me installed this on the C:\ drive and we now only have 64meg left on the C:\ drive.

    Help! Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. CHECKPOINT on the database

    2.take backup of tranlog to a different drive
    or
    BACKUP LOG databasename with no_log
    3. dbcc shrinkfile on the log file

    4. ALTER DATABASE to add new log file to a different drive

    5. DBCC SHRINK file with EMPTY file on the c:\log file.

    6. ALTER database with REMOVE file
    c:\log file

    Refer BOL for the syntax of all the above commands.

Posting Permissions

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