SQL Server Performance

Ms SQL 2005 ldf file size grow bigger

Discussion in 'SQL Server 2008 General DBA Questions' started by michellesbs, Nov 3, 2010.

  1. michellesbs New Member

    I am using MS SQL 2005, recently i found that my ldf file grow bigger, but the database is not access by the users for a few months ago.
    How can i trace the history for below :
    1) who is accessing the database recently?
    2) what script / process is run before?
    thanks in advance.

  2. Luis Martin Moderator

    Dou you have Maintenance plan, like reindex, running for this database?.
  3. michellesbs New Member

    Hi Luis Martin,
    I do not have any maintenance plan for that database, or perform any job to the database.
    How do i check, any script was call to run for the database ?
  4. Luis Martin Moderator

    I presume your database have full recovery model.
    If this database is not in use, then you can change from full to simple, shrink ldf at that is all.
    Also you can set to "read only" to be sure ldf will no grow again.
  5. satya Moderator

    How many users are connected to this database?
    Do you have any import job or SSIS packages that runs regularly?

Share This Page