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

Replication Expand / Collapse
Author
Message
Posted Monday, December 28, 2009 8:46 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:44 PM
Points: 1,520, Visits: 739
Comments posted to this topic are about the item Replication

Thanx.
Vinay


http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
Post #839665
Posted Tuesday, December 29, 2009 12:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 12:53 AM
Points: 2,529, Visits: 2,402
My answer is correct, but it's luck!
The text of the question is incomprehensible and the explanation is more and more incomprehensible.
Post #839720
Posted Tuesday, December 29, 2009 1:01 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:58 AM
Points: 336, Visits: 249
The question is very unclear. I guess it should be:

We have server ABC and installed two instance on it ABC\First and ABC\Second. we setup the Transactional replication from ABC\FIRST to ABC\SECOND. after 1 week we UNinstalled instance ABC\Second(control panel\add remove program\... unINstall ABC\Second).

Only after reading the answer I understood the question.

Herman
Post #839722
Posted Tuesday, December 29, 2009 1:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 2, 2014 6:41 AM
Points: 1,287, Visits: 784
The QotD needs a Moderator !!!


Post #839727
Posted Tuesday, December 29, 2009 1:24 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
I clicked on the link...

...and I saw that the article 'apllies to Microsoft SQL Server 2000 Standard Edition'. Does it apply to SQL Server 2005, 2008, or even MSSQL 2000 Enterprise Edition? There's nothing about editions in the question...
Post #839730
Posted Tuesday, December 29, 2009 2:43 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
Jumble the words to get the correct Question ..



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #839742
Posted Tuesday, December 29, 2009 4:01 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:32 PM
Points: 700, Visits: 1,029
This question is pretty poorly worded...

"we setup the Transactional replication from ABC to ABC\first" - from this it sounds like ABC is just a default instance as no instance is specified.
"unstall" - must be a new option?
Post #839762
Posted Tuesday, December 29, 2009 6:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:47 AM
Points: 2,914, Visits: 2,525
The question implies that there are 3 instances of SQL Server (ABC (Default), ABC\First and ABC\Second). With Replication set up between ABC and ABC\First, the removal of ABC\Second may not have an impact. There is nothing pointing in your scenario between ABC\First and ABC\Second so the removal of ABC\Second should have absolutely no impact.

The way your anser is written, ABC is the name of the server, and ABC\First and ABC\Second are the 2 instances of SQL Server. Thus, you cannot have replication between ABC and ABC\First. Thus, the answer would still be nothing because you cannot have replication between the server and an instance so Replication cannot be installed. Thus the replication must have been installed between the 2 instances, and now your answer is correct.

In addition, please see the remarks above about the various editions and how they work.

This is a very poorly described scenario.


Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #839810
Posted Tuesday, December 29, 2009 8:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 2,373, Visits: 2,726
I have to agree with the comments that the question was poorly worded. I would have gotten the question wrong anyway, but I couldn't even hazard a decent guess based on the way it was asked.

- webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #839859
Posted Tuesday, December 29, 2009 8:37 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, September 12, 2014 1:54 PM
Points: 718, Visits: 112
poorly written question, misspelled words
grammar incorrect

does anyone read the questions before they are posted?

OH - now I understand - the proof reading is outsourced to a foreign country where they speak fractured english



Post #839869
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse