InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 15:21:27 GMT20http://www.sqlservercentral.com/Forums/Topic999654-357-1.aspxYou can move the files, after the service has been stopped but there is no need as new ones are createdThu, 17 May 2012 00:55:10 GMTSQLDBA360http://www.sqlservercentral.com/Forums/Topic999654-357-1.aspxThanks for you reply.. but after executing this alter statement...can we do to move .mdf,.ldf to other location? or not ?Thu, 17 May 2012 00:49:11 GMTmohan.bndrhttp://www.sqlservercentral.com/Forums/Topic999654-357-1.aspxYes, after you're restarted the server instance. You'll know it is no longer in use when the OS allows you to delete it; as long as it's attached by SQL Server, you won't be able to.Wed, 06 Oct 2010 11:59:21 GMTRob Schripsemahttp://www.sqlservercentral.com/Forums/Topic999654-357-1.aspxThen the tempdb.mdf file in original D:\ drive can be deleted?Wed, 06 Oct 2010 11:48:22 GMTRanzzhttp://www.sqlservercentral.com/Forums/Topic999654-357-1.aspxAssuming tempdb logical names are the defaults (which they likely are):[code="sql"]USE master;GOALTER DATABASE tempdbMODIFY FILE (NAME = tempdev, FILENAME = 'H:\SQL\tempdb.mdf'); -- as in 'c:\tempdb.mdf'GOALTER DATABASE tempdbMODIFY FILE (NAME = templog, FILENAME = 'H:\SQL\templog.ldf'); -- as in 'c:\templog.ldf'[/code]After this you'll have to stop and restart your SQL instance.Wed, 06 Oct 2010 11:40:25 GMTRob Schripsemahttp://www.sqlservercentral.com/Forums/Topic999654-357-1.aspxwhat is the alter tempdb command to move the tempd.mdf file from D:\MSSQL2005\MSSQL$Instance\MSSQL.1\MSSQL\Data to the H:\SQL directoryWed, 06 Oct 2010 11:10:14 GMTRanzz