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

preview_player
Показать описание
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
  1. Sql Training Sessions
  2. DATABASE FILES--MDF
  3. Primary data file in sql server
  4. log file in sql server
  5. what is ndf file in sql server
  6. does database objects stored in hard disk
Рекомендации по теме
DATABASE FILES--MDF,LDF AND 0:19:04

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

How to analyze 0:04:12

How to analyze data from SQL Server MDF, NDF & LDF Files

SQL server tutorial 0:01:43

SQL server tutorial how to move SQL database files MDF and LDF to another location

How to move 0:05:15

How to move SQL Server Database MDF/LDF files to new location (change database location)

MDF Vs LDF 0:02:19

MDF Vs LDF in SQL Server || Master data File Vs Log Data File || Database

SQL : What 0:00:55

SQL : What are NDF Files?

How to add 0:04:54

How to add ( .ndf/.ldf ) files on mirror database of SQL Server || SQL server Database Mirroring.

SQL Server .mdf 0:05:24

SQL Server .mdf and .ldf files location change from one drive to another drive. Move .mdf and .ldf

SQL SERVER DBA 0:38:53

SQL SERVER DBA tutorials || Demo - 4 || by Mr. Ahmed Shareef On 06-09-2024 @3PM IST

How to Open 0:01:25

How to Open SQL Database file(MDF/NDF) Using SysInfo Free SQL file Viewer

Understanding NDF Files: 0:01:18

Understanding NDF Files: An Overview

MDF||LDF in Sql 0:00:37

MDF||LDF in Sql server

How to Reduce/Shrink 0:01:46

How to Reduce/Shrink LDF File Size using SQL Management Studio

Connection to sql 0:00:52

Connection to sql server database file (.mdf) require localdb fix in a simplest way.

SQL Interview Questions 0:07:37

SQL Interview Questions and Answers | Hindi | .MDF/.LDF File in SQL Server ? | #07

How To Move 0:06:34

How To Move SQL Server Database Files To A Different Location

How to attach 0:02:14

How to attach database mdf file in sql server and fix an error occurred when attaching the database

How to move 0:09:15

How to move SQL Server User database files (MDF and LDF) to another location

Databases: SQL Server 0:01:42

Databases: SQL Server - Move data from secondary ndf file to primary mdf file

Move User Database 0:11:49

Move User Database (.mdf and .ldf files) to another drive in SQL Server || Ms SQL

Import mdf database 0:01:04

Import mdf database file to SQLServer

Recover & Rebuild 0:01:42

Recover & Rebuild a database without a SQL Server Transaction Log File (.LDF).

SQL Server DBA 0:07:38

SQL Server DBA Tutorial 38-How to Shrink MDF Database Data File in SQL Server

How to copy 0:02:20

How to copy Sql file .mdf and .ldf to another location.

Комментарии
Автор

Thanks for this video, Excellent explanation.

rajbandaru
Автор

very informative video mam for the beginners

rajkumars
Автор

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

Kingbezy
Автор

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

balajianjansai
Автор

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

ajitsaharan
Автор

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

venkayyanaidu
Автор

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

abhay
Автор

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

ashishdev
Автор

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

thefilmythings
Автор

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

devanaidu
Автор

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

tshiamobaepi
Автор

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 .

dimpledivya
Автор

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 ?.

ranadheera
Автор

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

jingtingong
Автор

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

dimpledivya
Автор

White Barbara Garcia Laura Williams Kenneth

HarveySidney-ro
Автор

you waste huge time to deliver 1 minute message :(

mabushuhada
Автор

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

amarcse