<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Mirroring doubt
Mirroring doubt
Rate Topic
Display Mode
Topic Options
Author
Message
saidapurs
saidapurs
Posted Thursday, October 11, 2012 2:06 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167,
Visits: 413
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
Post #1371261
GilaMonster
GilaMonster
Posted Thursday, October 11, 2012 2:17 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744,
Visits: 30,025
http://msdn.microsoft.com/en-us/library/ms189852%28v=sql.105%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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
Post #1371269
saidapurs
saidapurs
Posted Thursday, October 11, 2012 3:40 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167,
Visits: 413
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
Post #1371310
Perry Whittle
Perry Whittle
Posted Thursday, October 11, 2012 3:47 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204,
Visits: 11,165
yes, the article details that.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1371314
saidapurs
saidapurs
Posted Thursday, October 11, 2012 3:56 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167,
Visits: 413
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
Post #1371319
GilaMonster
GilaMonster
Posted Thursday, October 11, 2012 4:39 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744,
Visits: 30,025
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 2008, MVP
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
Post #1371342
Perry Whittle
Perry Whittle
Posted Thursday, October 11, 2012 6:43 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204,
Visits: 11,165
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"
Post #1371429
saidapurs
saidapurs
Posted Thursday, October 11, 2012 6:47 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167,
Visits: 413
Thanks Pretty,
Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.
Thanks
Satish
Post #1371432
Perry Whittle
Perry Whittle
Posted Thursday, October 11, 2012 6:55 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204,
Visits: 11,165
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"
Post #1371438
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
