Configure DB Mirroring on 2 SQL Servers on different SPs

Question

Configure DB Mirroring on 2 SQL Servers on different SPs

Kishore-132325

Hall of Fame

Points: 3784
More actions
October 10, 2012 at 1:54 am

#282983

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

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

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" 😉

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

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" 😉

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

Thanks for reply..

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

swarn_soft Old Hand Points: 351 More actions · Answer 5

@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

Kishore-132325 Hall of Fame Points: 3784 More actions · Answer 6

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.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 7

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" 😉

Kishore-132325 Hall of Fame Points: 3784 More actions · Answer 8

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.