Diff between xxx_data.mdf and xxx.mdf files
From: Ashish Kanoongo (ashishk_at_armour.com)
Date: 07/05/04
- Next message: Hari Prasad: "Re: Multiple Instances - Properties tuning"
- Previous message: Steen Persson: "Re: Best eqivalent to a Data Transform Task"
- Next in thread: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Reply: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Reply: Jacco Schalkwijk: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Jul 2004 17:24:30 +0530
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: Hari Prasad: "Re: Multiple Instances - Properties tuning"
- Previous message: Steen Persson: "Re: Best eqivalent to a Data Transform Task"
- Next in thread: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Reply: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Reply: Jacco Schalkwijk: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
