Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are mdf,ndf,ldf files and how to see the data in those
files?

Answer Posted / padma

When we create a db,the create command will create a data
file with an Extension .mdf,as well as a transaction log
file with extension .ldf
Any additional or secondary data files have .ndf extension

Is This Answer Correct ?    121 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between cartesian product and cross join?

901


What is transact-sql language?

1134


What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

937


What is conditional split?

1141


How to find the service pack installed? : sql server database administration

1062


What is xml datatype?

1129


What are the steps to take to improve performance of a poor performing query? : sql server database administration

1089


Explain mixed authentication mode of sql server?

1115


What is a covered index?

985


What is the cartesian product of table?

1062


Can you explain important index characteristics?

1029


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1038


Explain why variables called the most powerful component of ssis?

1172


How to drop existing indexes in ms sql server?

1127


How do you delete duplicate rows in sql server?

1002