February 4, 2013 at 2:04 pm
I 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 risks
Your help is appreciated
Jeff
February 4, 2013 at 2:07 pm
You 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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2013 at 2:27 pm
my preferred method would be the alter database command
ALTER 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)
---------------------------------------------------------------------
February 4, 2013 at 2:37 pm
george sibbald (2/4/2013)
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)
If this is a SQL 2008 database server, I'd go that route too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2013 at 3:37 pm
works from 2005 up Jason.
---------------------------------------------------------------------
February 4, 2013 at 3:42 pm
Yup. 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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2013 at 9:17 am
Thank you very much for the help.
Jeff
Jeff
February 5, 2013 at 9:20 am
jayoub1 (2/5/2013)
Thank you very much for the help.Jeff
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2013 at 9:21 am
ditto
---------------------------------------------------------------------
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply