Mirroring doubt

Question

Mirroring doubt

saidapurs

Hall of Fame

Points: 3477
More actions
October 11, 2012 at 2:06 am

#393359

Hi All,
Some one asked me he configured mirroring both servers are in different location and mirroring is working fine..
1. How data will move from primary server to mirror server?
Thanks & regards
Satish

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

http://msdn.microsoft.com/en-us/library/ms189852%28v=sql.105%29.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

saidapurs Hall of Fame Points: 3477 More actions · Answer 2

Thanks Gila,

I read the article and as per my understand through Transaction log data will flow to mirror server. Please let me know if i wrong...

Thanks & regards

Satish

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

yes, the article details that.

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

"Ya can't make an omelette without breaking just a few eggs" 😉

saidapurs Hall of Fame Points: 3477 More actions · Answer 4

Hi Gila/Perry,

One of my great senior asked me below two questions and i gave the answer but he not agree, please response of your view..

1. What are SQL Server Dependency ?

My response :- All objects

2. What are SQL Cluster dependence ?

My Response :- Cluster admin, storage, etc

Thanks & regards

Satish

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

https://www.google.com/search?q=SQL+Server+dependencies

https://www.google.com/search?q=cluster+dependencies

If you're unsure after reading through, please ask.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

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

saidapurs (10/11/2012)
Hi Gila/Perry,
One of my great senior asked me below two questions and i gave the answer but he not agree, please response of your view..
1. What are SQL Server Dependency ?
My response :- All objects
2. What are SQL Cluster dependence ?
My Response :- Cluster admin, storage, etc
Thanks & regards
Satish

Right let's be straight are we talking mirroring or clustering here?

saidapurs (10/11/2012)
1. What are SQL Server Dependency ?
My response :- All objects

That is not a great response to be fair. At what level are we talking?

You could say that SQL Server depends on Windows, but thats stating the obvious.

Are you referring to a clustered or non clustered instance of SQL Server?

saidapurs (10/11/2012)
2. What are SQL Cluster dependence ?
My Response :- Cluster admin, storage, etc

A clustered instance of SQL Server typically has the following resources

Virtual IP address
Virtual Network name
clustered disk resources
SQL Server instance service
SQL Server instance agent service

The virtual name is dependant upon the virtual IP

The SQL Server service is dependant upon the disk and network name resources

The SQL Server agent is dependant upon the SQL Server service

Draw this out diagrammatically and you'll have yourself a small tree 😉

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

"Ya can't make an omelette without breaking just a few eggs" 😉

saidapurs Hall of Fame Points: 3477 More actions · Answer 7

Thanks Pretty,

Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.

Thanks

Satish

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

saidapurs (10/11/2012)
Thanks Pretty,
Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.
Thanks
Satish

Essentially, a mirror instance of SQL Server has the same dependencies as a non clustered instance (ignoring the mirrorred partner part of the equation)

Dependencies for a non clustered instance of SQL Server are pretty much taken care of by the OS.

a valid computername
a valid IP address
disk(s) where the sql server binaries and data files are stored

At the service level in Windows the SQL Server agent depends upon the SQL Server service.

Now start throwing in AlwaysOn groups or AO groups and FCIs then you have a real headache for dependencies 😉

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

"Ya can't make an omelette without breaking just a few eggs" 😉