Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configure DB Mirroring on 2 SQL Servers on different SPs Expand / Collapse
Author
Message
Posted Wednesday, October 10, 2012 1:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
I have 1 server with SQL Server 2008 R2 SP1 and another SQL Server on SQL 2008 R2 SP2.

I have DBs on server 1 where I need to configure DB mirroring b/w these 2 servers.

Should SP1 and SP2 [ different SPs ] create issues when configuring DB Mirroring or will it work ?

Thanks
Kishore
Post #1370744
Posted Wednesday, October 10, 2012 2:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:49 AM
Points: 6,626, Visits: 14,193
Firstly, why would you want to deploy a mirror session acros instances with differing SP levels?

Books Online does state the they should be the same version, i've never tried to implement mirroring across different SPs so can't say for sure


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1370756
Posted Wednesday, October 10, 2012 4:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
Mr. Perry, I have one question?

1. Principal server
SQL service account running under NT authority/Networkservice

2. Mirror server
SQL service account running domain account..

can we configure database mirroring on different service account, will it be work without any issues?

Thanks
ananda
Post #1370807
Posted Wednesday, October 10, 2012 4:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:49 AM
Points: 6,626, Visits: 14,193
ananda.murugesan (10/10/2012)
can we configure database mirroring on different service account, will it be work without any issues?

Thanks
ananda

You can, in fact each instance should use a separate user account.

Whether you should be using NT Authority\Network Service is the bigger question


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1370812
Posted Wednesday, October 10, 2012 4:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
Thanks for reply..

what could be bigger issues if using NT Authority/Network Service account in SQL server service? Pl. suggestion me

Post #1370818
Posted Saturday, October 13, 2012 12:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 26, 2013 1:07 PM
Points: 168, Visits: 117
@Kishore-132325,

For database mirroring, the primary and secondary, both servers must use same version and edition of SQL Server. but for the witness server you can use the different edition.
for more details see the link--
http://msdn.microsoft.com/en-us/library/ms366349(v=sql.105).aspx
Post #1372444
Posted Saturday, October 13, 2012 1:08 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
Well, I was able to configure with 2 different SP's - SP1 and SP2 on 2 Sql servers without any issues. All my user dbs are synchronized and working fine.
Post #1372458
Posted Sunday, October 14, 2012 8:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:49 AM
Points: 6,626, Visits: 14,193
OK, so when it states same edition and version it seems like it only refers to the major build version not the minor build version

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1372507
Posted Sunday, October 14, 2012 2:25 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
Yes, only the major build version, not SP's, unless those SP's have something very specific to that particular feature which will require both the partners onto the exact same version.
Post #1372535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse