InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 07:45:13 GMT20http://www.sqlservercentral.com/Forums/Topic993207-169-1.aspxNope. Sorry, you have to detach/attach. You do not have to do it through the GUI though; you can use SPs to accomplish it if you were wanting to script it out.[url=http://support.microsoft.com/kb/224071]How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server[/url]Sat, 25 Sep 2010 17:29:24 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic993207-169-1.aspxNope.Sat, 25 Sep 2010 05:32:02 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic993207-169-1.aspxI want to move data/log files from C drive to E drive.Is there any other option in SQL Server 2000 except of detach/atachSat, 25 Sep 2010 03:19:19 GMTPritam Salvihttp://www.sqlservercentral.com/Forums/Topic993207-169-1.aspxThanks for reply.Is there any way to do that except of doing detach/atach while copying from windows.Sat, 25 Sep 2010 03:17:20 GMTPritam Salvihttp://www.sqlservercentral.com/Forums/Topic993207-169-1.aspxThe ALTER DATABASE ... MOVE was not an option for any database other than TempDB on SQL 2000.Sat, 25 Sep 2010 02:57:09 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic993207-169-1.aspxHi all,I am using sql server 2000I am trying to use alter database option to move datafiles.But it showed me error below-Server: Msg 5037, Level 16, State 1, Line 1MODIFY FILE failed. Do not specify physical name.Look at the my qryALTER DATABASE NewTestDBMODIFY FILE (NAME = NewTestDB_Data, FILENAME = 'D:\SQLData\NewTestDB_Data.mdf');ALTER DATABASE NewTestDBMODIFY FILE (NAME = NewTestDB_Log, FILENAME = 'D:\SQLData\NewTestDB_Log.ldf');Whats wrong in this?Pls let me know why alter database is not happening.Sat, 25 Sep 2010 00:24:04 GMTPritam Salvi