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

Mirroring doubt Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 2:06 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
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
Posted Thursday, October 11, 2012 2:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
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
Posted Thursday, October 11, 2012 3:40 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
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
Posted Thursday, October 11, 2012 3:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:52 AM
Points: 6,291, Visits: 13,552
yes, the article details that.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1371314
Posted Thursday, October 11, 2012 3:56 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
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
Posted Thursday, October 11, 2012 4:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
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
Posted Thursday, October 11, 2012 6:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:52 AM
Points: 6,291, Visits: 13,552
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
Posted Thursday, October 11, 2012 6:47 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
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
Posted Thursday, October 11, 2012 6:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:52 AM
Points: 6,291, Visits: 13,552
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 »

Add to briefcase

Permissions Expand / Collapse