SQL Server Performance

how to change log file's settings

Discussion in 'ALL SQL SERVER QUESTIONS' started by hayko98, Feb 8, 2012.

  1. hayko98 New Member

    Hi all,
    I created datebase(SQl 2008) and placed my mdf file in F drive ,ldf file in G drive.I am trying to increse log files size.When i go to database's property/files i don't see log file.How do i change log files settings from SSMS?
  2. Jon M Member

    It should be under "Files Page".
  3. Luis Martin Moderator

  4. Asheesh pandey New Member

    To increase the size of existing file you can go in files and then set initial size or you can add file to increase database size.

Share This Page