DATABASE FILES--MDF,LDF AND NDF IN SQL SERVER | How data is actually stored in sql server

This session will help you understand following concepts -
1.) What is DATABASE FILES--MDF,LDF AND NDF IN SQL SERVER
2.) What is primary data file in sql server?
3.) What is secondary data files in sql server?
4.) What is transactional log files in sql Server?
5.)how data is actually stored in sql server ? On drives,on hard disk?
6.) How databases objects gets stored in database files?
Thanks for Watching!
By Sql training Sessions
By SQL
Thanks for watching
BY SQL SERVER TRAINING SESSIONS
BY SQL

[@hrushikeshkhonde7079]

Nice explanation.... Thanks mam...

[@rajkumars1204]

very informative video mam for the beginners

[@Kingbezy]

Thanks for this! This video is GOLD🔥💯thank you!

[@rajbandaru618]

Thanks for this video, Excellent explanation.

[@LearnWithMRajput]

Glad to know that it is useful

[@balajianjansai9622]

Best sql tutorials I have ever seen please man can you continue the same

[@LearnWithMRajput]

Sure

[@Deepak-kk3wz]

​@@LearnWithMRajputHi, I have one small but very complex query on SQL . Can you please help me
Thanks.

[@BCTAHbKA]

Das ist das geilste Video ever

[@balaanji2877]

Excellent

[@hayalgeta6024]

Thanks!!!! Awesome!!

[@balakrishnareddithala8718]

sql professor...

[@rahulborate7034]

Big Thanks for your work.

[@GENADIKRASTEV]

Thank you for the great video Teacher

[@LearnWithMRajput]

Your welcome...keep watching

[@amangupta-ll3rs]

Thanks for the tutorial.

[@SumantKumar-fn5td]

Good job mam..!!

[@LearnWithMRajput]

Thanks Sumant.

[@prakashboksham8673]

Super..

[@amitbhardwaj8801]

Thank you ma'am

[@nandini5141]

Thanks a lot!

[@chiranjeevikatta8116]

clearly mention about .ndf files

[@ajitsaharan9445]

First of all thank u for these beautiful videos! I have one ques "How would .ndf file synchronize with mdf file?"

[@LearnWithMRajput]

Both MDF and ndf files are data storage files .....once the primary file mdf got completely filled up as per the space allocated to it....sql server starts storing data in secondary files ...ndf

[@phaneendrasubnivis607]

@@LearnWithMRajput this need not be always true. Intentionally we can have tables getting stored in secondary files. We get the benefit if the main and secondary files are stored in different physical drives and hardware is capable of reading data from different physical drives in parallel

[@abhay6276]

but maam we store the data on server where lots of space is available we not store in our pc .

[@ashishdev7999]

Where is .ndf creation scenario, i was waiting for that scenario.
How to add ndf and remove after use

[@bhavinmer1651]

Same here

[@venkayyanaidu9227]

Hi Madam, Can you please give a query to create a new database with mdf, ldf, ndf file in different drives. Thanks You.

[@thefilmythings]

mam i am begainer , after new data base name , in my device only show my file name in c drive not shown mdf and ldf , only shown my file name . why? plz help me

[@devanaidu9406]

Hello mam..can you please make a video on how to create and generate ER reports

[@dimpledivya2315]

Mam I have a problem In sql server DATA folder in DATA Folder the files are not shows like as your folder they shows In other format. So please help me mam .

[@tshiamobaepi7193]

Thanks very Much. How can i reduce data to free space on the disk?

[@foolchandsonariwal4203]

How we can create ndf file

[@ranadheera7574]

You said when c drive full .ndf file will create. You didn’t show it by creating. Will it create by auto once c drive full?. Once .ndf file create .mdf file go away?. Or .ndf file replaces the .mdf file?. .ndf takes less space of c drive the .mdf file?. What is the use of .ndf ?.

[@LearnWithMRajput]

Dear Rana,.. 1)first of all...ndf file is not created automatically..it is user defined secondary file. ...2) When your primary file .MDF reached its maximum size, (say you have given 3gb to MDF file while creating database), then to store data we need additional files other than primary file which already got filled ..in that case you need to create ndf file. 3) No, .mdf will not go away 4) No , like I said .ndf file not replaced .mdf file...it's like when .mdf file is no longer to hold data...then .ndf file holds remaining data.4)by default, database files got created on C drive, you can create .ndf files on other drives like E,D drive.

[@LearnWithMRajput]

I hope i have satisfied your question.:)

[@jingtingong6177]

Hi, how u change the * to all the column name in 14:28?

[@dimpledivya2315]

How to send the image to you for clearly understand the problem....please please help me

[@LearnWithMRajput]

Hello Dimple, you can write your problem query with attachment to [e-mail].I would be happy to assist you further.

[@HarveySidney-r7o]

White Barbara Garcia Laura Williams Kenneth

[@mabushuhada]

you waste huge time to deliver 1 minute message :(

[@satyampalofficial]

Published Video Hindi

[@LearnWithMRajput]

Hi ..do you want me to publish vedios in hindi?

[@satyampalofficial]

Yes

[@LearnWithMRajput]

Ok sure

[@lakhpatsingh300]

Time consuming video

[@amarcse06]

Please provide you r email id mam to contact for training..regarding index tunning

[@bhavinmer1651]

How to created .ndf files ?

[@LearnWithMRajput]

Usually .ndf got created automatically once the space allocated by .mdf file is fully occupied