SQL Server Performance Forum – Threads Archive
Naming data files
I have a doubt on database files naming. These databases were created by some other guy whose is not working now and I wud like to know the reason behind naming this database files in such a way, is there any advantage? I have 2 databases namely1.padot (padot.mdf, padot_ext_data.ndf, phhs_data_ext.ndf) 2.phhs (padot_data_ext.mdf, phhs.ndf, phhs_data_ext2.ndf, phhs_data_extension.ndf) You can observe the names of ndf files, why does some of the names look like same,will there be any interconnection between these 2 database,is there any affect on the database when working on the other. This may look silly but I am bit confused with names, can any one has any idea? Thanks!
"He laughs best who laughs last"
When you create a new extension of database, SQL for convention use ndf instead mdf.
Is not important. May the guy before confuse one database with other, that’s why: 1. padot (……..phhs_data_ext.ndf) has similar names than
2. phhs (padot_data_ext.mdf) Any extention should begin with same name than database name, just for good pratices.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
SQL server treates phhs.ndf, phhs_data_ext2.ndf, phhs_data_extension.ndf as a seperate files and you can have many number of .NDF files which are treated as secondary data files. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Don’t worry. Although this naming looks a little bit strange, you don’t have to fear any interconnection between both databases. A database file ALWAYS belongs to just one database. They cannot be shared. to me this looks like someone RESTOREd a backup under a different name.
—
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
]]>