Post reply

Renaming system databases

  • April 29, 2013 at 12:41 pm

    #1610949

    IT researcher (4/29/2013)

    The only reason to rename the file is for automated backup. I do have my own backup application where I can automate backup on daily,weekly or monthly basis. I am using it from so long time. Now i have shifted the all system database from installation directory to non windows drive just for security and disaster recovery plan. Till now I did't have backup for system database and now I am planning to include to it. But the backup application requires the database name and it's mdf file name to be same.(In my case only msdb has different mdf name as MSDBData.mdf . So I needed to rename the file. I just tested renaming the file in a test server and it worked fine.

    I agree with the rest. If you have a backup utility that requires the name of the MDF and LDF file to be identical, then you've made a serious mistake in your selection of utilities. Find a better utility or write on your self. It's just not that difficult and any utility that requires such a name change should be introduced to the ol' Unit Zero immediately.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing post 16 (of 15 total)

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