SQL Server Performance

Transaction Log Space

Discussion in 'General DBA Questions' started by vuacorona, Mar 15, 2007.

  1. vuacorona New Member

    Hi All:

    The transaction log is 97% full, I need to increase more space. Would you please help?

    thanks
    vua

  2. MohammedU New Member

    If database recovery model is full then run the tlog backup...
    OR
    You can increase the log size using EM or QA...
    In query anyalizer you can user ALTER DATABASE command..

    What are mdf and ldf and ndf file sizes? Check first what is causing your log file to grow 97%....


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page