Contained database in SQL server | How to create a contained database | Ms SQL
Вставка
- Опубліковано 30 чер 2024
- Contained databases feature is available at instance level and it is not enabled by default.
If we want to create a new database as a contained database, we have to make containment type as Partial in the Options page.
Contained database feature provides two containment modes:
None - By default each database has its mode set as NONE. This means there is no contained database feature being used.
Partial - With partially contained databases, we can define boundaries between databases and the server, so the metadata will exist inside the databases. It makes SQL Server databases more portable and less dependent on underlying hosts.
Before allowing contained databases, one should understand the risks associated with contained databases. Click below link to check the Best Practices with Contained Databases.
learn.microsoft.com/en-us/sql...
--To check if database is contained
select containment,name from sys.databases where name='DEMO'
--To check which users are listed as contained users
SELECT name,type_desc,authentication_type_desc
FROM sys.database_principals WHERE authentication_type =2
Please watch complete video for a better understanding @righttolearnbk
Sir your videos are awesome and helping us to learn the topics from basics. Also ,the presentation is very good and we can see the hardwork behind each of your content .All your videos are helpful .Please keep doing the same. Thankyou Sir.
Please do video on estimated execution and actual execution plans. More videos on performance tuning will be helpful us🙏
Ok
@@righttolearnbk Thank you 😊
Thanks helping
@sir please make a video on Always on top 10 repeated issues and troubleshooting
Sure
Happy New year sir
Happy new year
Dear happy new year
Dear sir pls make video on if master database got currepted then what will do next pls explain step by step.
We have to Rebuild Master Database. Will make a video on it in coming days.