Creating New DB - Filename (mdf/ldf) ???

  • Hello,

    We're upgarding ... new install ... MSSQL2005 S.E/RTM

    When creating a new database using mssql Server Man Studio, why is everything editable except "Filename" ie: it's blank with a blue/greay fill ... why can I edit the logical name but not Filename?

    ie: Create db called db ... Logical Names = db and db_log and the OS files (File name)  created by default are db.mdf and db_log.ldf.

    I would like to remove the "_log" so the OS files are db.mdf and db.ldf.

    Is there a way? We use to be able to specify this in earlier MSSQL versions.

     

    Many thanks. Jeff

  • do it in T sql.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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