HOW TO RENAME EXTENTION OF MDF FILE?

Total Post:0

Points:0
 234  View(s)
Ratings:
Rate this:
  1. Post:37

    Points:185
    How to Rename Extention of MDF File?

    CREATE DATABASE [mindstick]
    ON PRIMARY
    ( NAME = N'[[mindstick]]', FILENAME = N'D:\mindstick.pdf' )
    LOG ON
    ( NAME = N'[[mindstick]]_log', FILENAME = N'D:\mindstick.ldf')
    GO

     

    Next step is to take database offline Click on task>offline

    ALTER DATABASE [mindstick] 
    MODIFY FILE (name = 'mindstick',
                filename = 'D:\mindstick.mdf')
    GO
     

     

    Next step is to change the name then take it online from offline

      Modified On Mar-29-2018 01:55:09 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!