Post reply

Detach database

  • August 8, 2011 at 4:00 pm

    #245934

    Can we rename .ldf file which it's corresponding database is detached?

    Thanks..

  • August 8, 2011 at 4:03 pm

    #1365569

    you would have to offline the database, use alter database modify file, physiacally rename the file, then online the database again.

    so the database won't be detached but you will need exclusive use.

    back it up first.

    ---------------------------------------------------------------------

  • August 8, 2011 at 4:05 pm

    #1365571

    Just curious - why?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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