Can two databases be the same?

Question

It is not possible to have two databases point to the same database files, except in the weird Autoclose case that you linked to, which no one should be using that setting anyway. With that information, you should be able to see that the databases are in fact not pointing to the same database files. 28 июн. 2017 г.

Can I use 2 databases?

You can use two databases the same reason most banks have two ATMs, for reliability. You can swap one in if the other fails, but to do it quickly requires setup, such as a cname and controlling your own DNS server.

Can we have more than one database with same name?

You cannot have 2 databases or two named instances with same name. System databases cannot be detached and attached.

Can two websites have the same database?

So yes it is possible to allow both applications to share the same database.

Can databases be connected to each other?

A pool of database connections can be created and then shared among the applications that need to access the database. The connection object obtained from the connection pool is often a wrapper around the actual database connection.

Expert · Answer