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 123»»»

LogShipping Expand / Collapse
Author
Message
Posted Monday, February 21, 2011 9:05 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 5, 2014 9:54 PM
Points: 1,683, Visits: 451
Comments posted to this topic are about the item LogShipping


- Pradyothana


http://www.msqlserver.com
Post #1067391
Posted Monday, February 21, 2011 9:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:52 PM
Points: 2,270, Visits: 3,789
Not in Primary should also be correct.

Mohammed Moinudheen
Post #1067392
Posted Monday, February 21, 2011 11:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:32 AM
Points: 1,904, Visits: 2,845
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.


Got it right, but was a bit confusing, as I agree that there are multiple correct answers.


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1067413
Posted Tuesday, February 22, 2011 12:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 13,606, Visits: 10,490
Nice easy question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1067420
Posted Tuesday, February 22, 2011 12:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 13,606, Visits: 10,490
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.


That is not true.
Not in Primary is the same as saying: on every server that is not the primary server. This could include a monitor server. However, the copy job is not installed on the monitor server.

Edit: it is debatable if there isn't a monitor server. But then again, if there is one obviously correct answer and another "with much doubt" correct answer, what would you choose?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1067421
Posted Tuesday, February 22, 2011 3:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
I like it when I learn something new from this, had to do a bit of reading but got there in the end. Yay!

Agree regarding "Not in Primary" being the wrong answer, although worded in such a way to catch the unwary out, the fact is that the Monitor server (if employed) would not have a copy.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1067473
Posted Tuesday, February 22, 2011 6:42 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
all of these answers could be correct.

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

Post #1067574
Posted Tuesday, February 22, 2011 6:46 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
Koen Verbeeck (2/22/2011)
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.


That is not true.
Not in Primary is the same as saying: on every server that is not the primary server.


How so? Without more detail in the question Not in primary can only mean its not installed on the primary, which is a correct answer.


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

Post #1067576
Posted Tuesday, February 22, 2011 6:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
You are very true George.

Maybe the OP was giving a point for peoples ability to filter out the wheat from the chaff and not be pedantic...



_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1067579
Posted Tuesday, February 22, 2011 6:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 13,606, Visits: 10,490
george sibbald (2/22/2011)
Koen Verbeeck (2/22/2011)
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.


That is not true.
Not in Primary is the same as saying: on every server that is not the primary server.


How so? Without more detail in the question Not in primary can only mean its not installed on the primary, which is a correct answer.


I understand your point.
I was looking at the phrase "Not in Primary Server" from a logical (mathematically speaking) view, where you can translate "Not in Primary Server" into "Installed everywhere else".

A little farfetched, but hey, I didn't have my morning cup of coffee when I posted that...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1067582
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse