Post reply

Changing Logical File Names

  • December 6, 2005 at 4:03 pm

    #110957

    I have inherited a database with inconsistent logical file names. sp_helpdb returns the following (note 93's v. 99's)...

    name filename

    db_referral_1_93_Data F:\sqldata\db_referral_1_99.MDF

    db_referral_1_93_Log F:\sqllogs\db_referral_1_99.LDF

    When I backup, delete, create (with consistent names and filenames) and restore the backup to the new database, the inconsistent logical file names return. Any suggestions appreciated.

    Thanks,

    Dave

  • December 6, 2005 at 10:11 pm

    #608116

    This script handles this:

    http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=764

    Andy

  • December 7, 2005 at 7:40 am

    #608171

    How about this:

    ALTER DATABASE database MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...)

    For more information search for ALTER DATABASE in BOL.

  • December 7, 2005 at 11:23 am

    #608235

    I appreciate the suggestions offered in response to my question.

    Thanks,

    Dave

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

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