Home Forums SQL Server 2008 Working with Oracle is it possible to have Single instance(name or SID) on multiple database? RE: is it possible to have Single instance(name or SID) on multiple database?

  • In SQL Server, you have an instance that contains control information, scheduling, logins, etc. and then you can have multiple databases inside the instance. The instance is at a higher level, and acts as a container for the databases.

    You can have multiple instances on a Windows host, but each of those has it's own databases.