Post reply

Changing Logical File Name

  • August 11, 2003 at 9:14 am

    #106794

    I restored a backup and created a new database. The new database inherited the same logical file names (Old, Old_log).

    How do I change them?

  • August 11, 2003 at 9:22 am

    #469431

    If you are running SQL Server 2000, change it after the restoration using alter database command with modify file option.

    You can't do it in 7.0

  • August 11, 2003 at 9:24 am

    #469432

    THANK YOU!

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

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