Click here to read “How to Configure a Contained Database Feature in SQL Server” article from the beginning.
How to Connect to Contained Database in SQL Server
Step 1. In Connect to Server, Login tab enter Server Name, choose Authentication, enter Login and Password as shown in the below snippet and click on Connection Properties tab.

Step 2: In Connection Properties tab specify the database name as shown in the snippet below and finally click the Connect button.

In the below snippet you could see that using the contained database login you could just see only one database to which your login belongs and the login doesn’t have access to Database Engine.

Conclusion
Now that you have successfully connected to a contained database you can easily easily create the Backup of the Contained Database and Restore it on any other instance of SQL Server.
Add comment