how to change log file settings

  • 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?

  • Interesting that you cannot see the log file in database property, can you post a screen shot of the database property?


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Sorry, i can't.

  • All i see is mdf file

  • Hi vardan.hakopian,

    When ever you creates a database, You must had the option popup besides the window Filename.(If you want you can change this different than Logical Name)

    Logical Name and Physical Name/FileName 's are two different things for the same database.

    Logical Name should be Your Given database Name as 'SQl 2008' for Mdf and 'SQl 2008_log' for the ldf.

    Of course, By default Physical/ File Names should be 'SQl 2008.mdf' and 'SQl 2008_Log.ldf' .

    Unless you chose different names for your requirement.

    Database (SQl 2008)--> Properties --> Files -->

    Now you can take the scroll button and go all the way to the right until you see the File Name.. Please take a look for .ldf file under FileName Coulmn.

    I hope it helps.

  • There is only 1 row for mdf

  • vardan.hakopian (2/8/2012)


    There is only 1 row for mdf

    Run the below script and see what you get..

    SELECT * FROM MASTER..SYSALTFILES WHERE dbid = DB_ID('Database_Name')

    Replace Database_name with the database that you are working on..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Are you looking at a database snapshot perhaps rather than a normal database?

    Why can't you post a screenshot?

    What's the output of this when run in that database?

    SELECT type_desc ,

    data_space_id ,

    name ,

    physical_name ,

    state_desc ,

    size ,

    max_size ,

    growth

    FROM sys.database_files AS df

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • fileidgroupidsizemaxsizegrowthstatusperfdbidnamefilename

    111862400-138400208PRDE:\DB_Data\PRD_COPY.mdf

    20704000-110104864208PRD_logG:\DB_Log\PRD_COPY_log.LDF

  • type_descdata_space_idname physical_name state_descsize max_size growth

    ROWS 1 PRD E:\DB_Data\COPY.mdfONLINE1862400 -138400

    LOG 0 PRD_log G:\DB_Log\COPY_log.LDFONLINE704000 -110

  • type_desc data_space_id name physical_name state_desc size max_size growth

    ROWS 1 PRD E:\DB_Data\PRD_COPY.mdf ONLINE 1862400 -1 38400

    LOG 0 PRD_log G:\DB_Log\PRD_COPY_log.LDF ONLINE 704000 -1 10

  • type_desc data_space_id name physical_name state_desc size max_size growth

    ROWS 1 PRD E:\DB_Data\PRD_COPY.mdf ONLINE 1862400 -1 38400

    LOG 0 PRD_log G:\DB_Log\PRD_COPY_log.LDF ONLINE 704000 -1 10

  • vardan.hakopian (2/8/2012)


    fileidgroupidsizemaxsizegrowthstatusperfdbidnamefilename

    111862400-138400208PRDE:\DB_Data\PRD_COPY.mdf

    20704000-110104864208PRD_logG:\DB_Log\PRD_COPY_log.LDF

    If that returns more than 1 record, it should then display you the same number of rows in database properties (when you select files page)..

    Can you ensure you close the properties dialog box and retry one more time and see what is displays..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • OK.I was connecting to this server from my workstation.When i actualy opened SSMS from that server it shows both files.Looks like problem comes from my workstation.

  • Any idea what is wrong with my SSMS?

Viewing 15 posts - 1 through 15 (of 19 total)

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