Skip to main content
Database Administrators

Return to Question

added 40 characters in body; edited title
Source Link
marc_s
marc_s
  • 9k
  • 6
  • 45
  • 52

MSSQL server SQL Server 2012 database 3 mirroring questions

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL EditionsServer editions have to have the same name? I I.E Atat the moment iI have 3 seversservers labeled ABC-SERVER1ABC-SERVER1, ABC-SERVER2ABC-SERVER2, ABC-SERVER3ABC-SERVER3. My main sqlserver is called SQL-SERVER3SQL-SERVER3 on server3, would iI then have to have the named instance SQL-SERVER3SQL-SERVER3 running on ABC-SERVER2 ANDABC-SERVER2 and 1?

  2. If the SQl serverSQL Server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1SQL ABC-SERVER1), (ABC SQL-SERVER2ABC SQL-SERVER2) ETCetc... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As iI understand it you can have 2 SQL VERSIONSServer versions running at any one time from the 1 licence, as long as only 1 instance of SQL serverServer is in use at any one time. To get a witness running iI would have to use a SQL expressServer Express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....

MSSQL server 2012 database 3 mirroring questions

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL Editions have to have the same name? I.E At the moment i have 3 severs labeled ABC-SERVER1, ABC-SERVER2, ABC-SERVER3. My main sql is called SQL-SERVER3 on server3, would i then have to have the named instance SQL-SERVER3 running on ABC-SERVER2 AND 1?

  2. If the SQl server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1), (ABC SQL-SERVER2) ETC... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As i understand it you can have 2 SQL VERSIONS running at any one time from the 1 licence, as long as only 1 instance of SQL server is in use at any one time. To get a witness running i would have to use a SQL express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....

SQL Server 2012 database 3 mirroring questions

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL Server editions have to have the same name? I.E at the moment I have 3 servers labeled ABC-SERVER1, ABC-SERVER2, ABC-SERVER3. My main server is called SQL-SERVER3 on server3, would I then have to have the named instance SQL-SERVER3 running on ABC-SERVER2 and 1?

  2. If the SQL Server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1), (ABC SQL-SERVER2) etc... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As I understand it you can have 2 SQL Server versions running at any one time from the 1 licence, as long as only 1 instance of SQL Server is in use at any one time. To get a witness running I would have to use a SQL Server Express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....

added 2 characters in body
Source Link
SoupOfStars
SoupOfStars
  • 23
  • 3

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL Editions have to have the same name? I.E At the moment i have 3 severs labeled ABC-SERVER1, ABC-SERVER2, ABC-SERVER3. My main sql is callcalled SQL-SERVER3 on server3, would i then have to have the named instance SQL-SERVER3 running on ABC-SERVER2 AND 1?

  2. If the SQl server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1), (ABC SQL-SERVER2) ETC... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As i understand it you can have 2 SQL VERSIONS running at any one time from the 1 licence, as long as only 1 instance of SQL server is in use at any one time. To get a witness running i would have to use a SQL express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL Editions have to have the same name? I.E At the moment i have 3 severs labeled ABC-SERVER1, ABC-SERVER2, ABC-SERVER3. My main sql is call SQL-SERVER3 on server3, would i then have to have the named instance SQL-SERVER3 running on ABC-SERVER2 AND 1?

  2. If the SQl server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1), (ABC SQL-SERVER2) ETC... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As i understand it you can have 2 SQL VERSIONS running at any one time from the 1 licence, as long as only 1 instance of SQL server is in use at any one time. To get a witness running i would have to use a SQL express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL Editions have to have the same name? I.E At the moment i have 3 severs labeled ABC-SERVER1, ABC-SERVER2, ABC-SERVER3. My main sql is called SQL-SERVER3 on server3, would i then have to have the named instance SQL-SERVER3 running on ABC-SERVER2 AND 1?

  2. If the SQl server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1), (ABC SQL-SERVER2) ETC... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As i understand it you can have 2 SQL VERSIONS running at any one time from the 1 licence, as long as only 1 instance of SQL server is in use at any one time. To get a witness running i would have to use a SQL express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....

Tweeted twitter.com/#!/StackDBAs/status/437310968197292032
Source Link
SoupOfStars
SoupOfStars
  • 23
  • 3

MSSQL server 2012 database 3 mirroring questions

I've been looking for the answer to these three questions but just cant find a straight answer..

  1. When mirroring with a witness, does all three SQL Editions have to have the same name? I.E At the moment i have 3 severs labeled ABC-SERVER1, ABC-SERVER2, ABC-SERVER3. My main sql is call SQL-SERVER3 on server3, would i then have to have the named instance SQL-SERVER3 running on ABC-SERVER2 AND 1?

  2. If the SQl server instances don't have to be labeled all the same i.e they can be (SQL ABC-SERVER1), (ABC SQL-SERVER2) ETC... If you are using a program for example MS Access and you connect to a server for example server3, how would access know where to go if server3 was offline?

  3. As i understand it you can have 2 SQL VERSIONS running at any one time from the 1 licence, as long as only 1 instance of SQL server is in use at any one time. To get a witness running i would have to use a SQL express edition or buy another licence, is that correct?

Thanks in advance for taking your time out to read this....