Re: Diff between xxx_data.mdf and xxx.mdf files
From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 07/05/04
- Next message: Jamie: "Cascade Deletes"
- Previous message: Hari Prasad: "RE: Multiple Instances - Properties tuning"
- In reply to: Ashish Kanoongo: "Diff between xxx_data.mdf and xxx.mdf files"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Jul 2004 13:32:22 +0100
I don't think there is any specific logic behind the file names really, it's just what the naming convention was at the time the databases were created. The actual database name is independent of the file name (and a database can consist of multiple files anyway, so it wouldn't make much sense to name the files after the database).
-- Jacco Schalkwijk SQL Server MVP "Ashish Kanoongo" <ashishk@armour.com> wrote in message news:e8c%23paoYEHA.3988@tk2msftngp13.phx.gbl... What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I created, attach and detach database manytimes. SOme time its shows the database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it only shows file name as "xxx.mdf and xxx.ldf", why? However in Enterprise manager it shows database na as "xxx". I just want to know difference these file name conventions, what was the logic behind this? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.715 / Virus Database: 471 - Release Date: 07/04/2004
- Next message: Jamie: "Cascade Deletes"
- Previous message: Hari Prasad: "RE: Multiple Instances - Properties tuning"
- In reply to: Ashish Kanoongo: "Diff between xxx_data.mdf and xxx.mdf files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
