Renaming logical files

• jima

  SSCrazy

  Points: 2192

  More actions

  September 29, 2004 at 9:45 am

  #161545

  Hi,

  Having trouble renaming logical db files using the Microsoft described way;

  ALTER DATABASE dbname

  MODIFY FILE(NAME=DB_Data, NEWNAME=DBTEST_Data)

  QA does not recognise 'NEWNAME' as an option but it's the Sql2K Manual !?!?

  ALTER DATABASE database

  { MODIFY FILE < filespec > }

  < filespec > ::=

  ( NAME = logical_file_name

      [ , NEWNAME = new_logical_name ]

      [ , FILENAME = 'os_file_name' ]

      [ , SIZE = size ]

      [ , MAXSIZE = { max_size | UNLIMITED } ]

      [ , FILEGROWTH = growth_increment ] )

   

  Can anyone shed any light on this ? or describe an alternate way I can get it to work ?

   

  Many thanks in advance.

   

  j 

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  September 29, 2004 at 9:58 am

  #524801

  Please see the below link:

  http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=139298

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net