Post reply

modify the database physical file name

  • November 25, 2004 at 12:53 pm

    #86951

    Is there a way to modify the database physical file name?

  • November 25, 2004 at 1:00 pm

    #531556

    Detach it, rename the file name and re-attach.

    You can change the logical file name too with "alter database modify file" command.

  • November 26, 2004 at 9:14 am

    #531624

    Allen's advice is the best way to do this.

  • December 3, 2009 at 9:05 am

    #1087188

    I issue the alter database and the modify file on my model database but I receive this answer:

    MODIFY FILE failed. Do not specify physical name.

    What should I do because I cannot use detach on the model database.

  • December 3, 2009 at 9:15 am

    #1087197

    Why do you want to change the name of a file of one of the system databases?

    p.s. Please in future ask new questions in a new thread, rather than resurrecting a 5 year old, answered thread

    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

Viewing 5 posts - 1 through 4 (of 4 total)

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