Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    15

    Question Unanswered: Filegroup name modify error

    Hİ everybody.i got a problem

    first i add filegroup;
    ALTER DATABASE test
    ADD FILEGROUP testgrup1

    then;(i add a data file)
    ALTER DATABASE test
    ADD FILE (NAME = test5, FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test5.ndf',
    SIZE=8MB, MAXSIZE=100MB,FILEGROWTH=10MB )
    TO FILEGROUP testgrup1
    GO

    -------------------------------------

    ALTER DATABASE test
    MODIFY FILE
    ( NAME = testgrup1, NEWNAME = testgrup3 )

    ALTER DATABASE test
    MODIFY FILE
    ( NAME = testgrup2, NEWNAME = testgrup4 )


    ^^^ BUT When I wrote this code, gives the following error!! v v v

    Msg 5041, Level 16, State 1, Line 1
    MODIFY FILE failed. File 'testgrup1' does not exist.
    Msg 5041, Level 16, State 1, Line 5
    MODIFY FILE failed. File 'testgrup2' does not exist.

  2. #2
    Join Date
    Mar 2012
    Posts
    15

    Thumbs up Thanks.i find

    THANKS.. I FIND
    --ALTER DATABASE test
    --MODIFY FILEGROUP testgrup1 NAME = testgrup3
    --GO
    TRUE


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •