Sql Server
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sql Server as PDF for free.
More details
- Words: 162
- Pages: 1
Different Databases in SQL Server-> 1) Master -> This is a master database which contains all the necessary tables in the database. 2) Model -> This is a database which contains the different models of the
database. 3) Tempdb-> This is a database which contains the temporarily database in it. 4) Msdb- > This is a database which contains the Microsoft Database in it. These are the built –in databases which are already designed in SQL Server Enterprise Manager.
Different File groups & Files in Sql Server-> 1) Primary Files -> These are the primary files in the SqlServer, by
default there is only one Primary File in the Sql sErver. Its extension is .mdf . The user can create his own primary file. 2) Secondary File- > These are the secondary files whose information is already stored in Primary files. 3) Log Files -> these have the extension .ldf which are used to store the information of the user.
Assignment ->
database. 3) Tempdb-> This is a database which contains the temporarily database in it. 4) Msdb- > This is a database which contains the Microsoft Database in it. These are the built –in databases which are already designed in SQL Server Enterprise Manager.
Different File groups & Files in Sql Server-> 1) Primary Files -> These are the primary files in the SqlServer, by
default there is only one Primary File in the Sql sErver. Its extension is .mdf . The user can create his own primary file. 2) Secondary File- > These are the secondary files whose information is already stored in Primary files. 3) Log Files -> these have the extension .ldf which are used to store the information of the user.
Assignment ->
Related Documents
Sql Server
November 2019 28
Sql Server
November 2019 18
Sql Server
May 2020 11
Sql Server
November 2019 35
Sql Server
May 2020 13