how to check TYPE OF DATABASE how find system and User database and what use of system database
MSSQL ADMINISTRATION IN HINDI | MSSQL DBA CLASS IN HINDI | LEARN MSSQL IN HINDI Creating a new database using the CREATE DATABASE statement
CREATE DATABASE database_name;
What Is A System Database And What Is A User Database?
System database
These databases will maintain and provide more information about the SQL server system like logins , databases , linked servers , jobs , schedules , reports , report data sources etc.
User databases are the database where we will create for storing the data and the user starts to work with the data.
Recovery Type of database
Log File
Logical unit of database Page MSSQL SERVER ADMINISTRATION IN HINDI
