Hi all,

I am using sql server 2000

I am trying to use alter database option to move datafiles.

But it showed me error below-

Server: Msg 5037, Level 16, State 1, Line 1

MODIFY FILE failed. Do not specify physical name.

Look at the my qry

ALTER DATABASE NewTestDB

MODIFY FILE (NAME = NewTestDB_Data, FILENAME = 'D:\SQLData\NewTestDB_Data.mdf');

ALTER DATABASE NewTestDB

MODIFY FILE (NAME = NewTestDB_Log, FILENAME = 'D:\SQLData\NewTestDB_Log.ldf');

Whats wrong in this?

Pls let me know why alter database is not happening.