Renaming SQL Server Logical File Name

• Cindy Benedict-265286

  Valued Member

  Points: 50

  More actions

  March 30, 2006 at 2:53 pm

  #365732

  I am trying to rename the logical file name of a database.  I am using the script below but receive a message "incorrect syntax near the keyword file"

  Alter Database BD Prueba HYD

  Modify File (name=Apodaca_HYD_Data, NEWNAME=BD_Prueba_HYD_Data)

  I don't see anything wrong with the script, but no matter what I've tried I haven't had any luck.

  Anyone have any ideas?

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  March 30, 2006 at 3:53 pm

  #629985

  Try this

  Alter Database [BD Prueba HYD]

  Modify File (name=Apodaca_HYD_Data, NEWNAME=BD_Prueba_HYD_Data)

  I doubt it likes the spaces in the database name

  hth

   

  David