Database – difference between Sql Server and Sql Server Instances

databasemirroring

I just want to clarify if there is a difference between the two terms. Right now we are actually planning to use database mirroring and I've been encountering the following sentences

  • databases must reside on different server
  • databases must reside on different server instances

is there a difference?

Best Answer

Yes. One server can have multiple instances installed at the same time (even of different versions, like 2008 and 2012) as long as their "name" is different (Which you set at install).

Basically this allows you to have multiple different installations at one server.