InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:37:09 GMT20http://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxdittoTue, 05 Feb 2013 09:21:55 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspx[quote][b]jayoub1 (2/5/2013)[/b][hr]Thank you very much for the help. Jeff[/quote]You're welcome.Tue, 05 Feb 2013 09:20:15 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxThank you very much for the help. JeffTue, 05 Feb 2013 09:17:09 GMTjayoub1http://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxYup. I always did the detach in 2005 after a bad experience. But yup - the syntax is supported in 2005. I don't recall the specifics of the bad experience.Mon, 04 Feb 2013 15:42:57 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxworks from 2005 up Jason.Mon, 04 Feb 2013 15:37:16 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspx[quote][b]george sibbald (2/4/2013)[/b][hr]my preferred method would be the alter database commandALTER DATABASE yourdb( NAME = logicalfilename, FILENAME = N'c:\t1dat2.mdf' --for example);then offline the database, actually rename the physical file and online the database again.take a backup first whatever way you do it!(backup\restore with move is in fact another option)[/quote]If this is a SQL 2008 database server, I'd go that route too.Mon, 04 Feb 2013 14:37:01 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxmy preferred method would be the alter database commandALTER DATABASE yourdb( NAME = logicalfilename, FILENAME = N'c:\t1dat2.mdf' --for example);then offline the database, actually rename the physical file and online the database again.take a backup first whatever way you do it!(backup\restore with move is in fact another option)Mon, 04 Feb 2013 14:27:47 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxYou can leave the extension off if you wish. I wouldn't recommend it but it does work.To rename it, detach perform the file rename and then reattach is what I would do.Mon, 04 Feb 2013 14:07:20 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1415488-146-1.aspxI noticed that one database file does not have an extension and the type is just File. I have an M:\ partition and when I look at the database files one just has the name and no .mdf extension. The file type is File. There are other .mdf files in the same folder and they are listed with the extension and type is SQL Server Database Primary Data File. Also in the properties of the database under File Name it just shows the name and no extension. Please let me know what I should do to correct this. Not sure if just renaming the file ABSdatabase.mdf will work without the database being detached or something. If I do rename the file with the extension are there any risksYour help is appreciatedMon, 04 Feb 2013 14:04:52 GMTjayoub1