Post reply

ldf fie growing and growing

  • November 24, 2006 at 10:07 am

    #193189

    Erratum: Subject: ldf file growing and growing

    MS SQL Server 2005 on Windows 2003 SP1

    2-3 hrs ago the ldf file of a DB started growing (reaching 6 GB) until the space on disk became 0.  We made some space by deleting files but the space disappeared again.  We don’t know what triggered this process.

    There is only one program (SSIS) that writes to that database but that program is not active; at least we don’t see it.

    We tried unsuccessfully to detach, take offline or shrink the database using   Managment Studio:  "the database is currently in use”.

    1. How could we detect which is the process hat has this effect?
    2. How could we reduce to a normal size the ldf file?

    Thank you very much,

    Dan

  • November 27, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • November 27, 2006 at 8:12 am

    #674077

    have you run sp_who to see what is running?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply