Replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Vinay Thakur » Replication

26 posts, Page 1 of 3

1 2 3 »»»

Replication

Rate Topic

Display Mode

Topic Options

Author

Message

Vinay Thakur-585143

Posted Monday, December 28, 2009 8:46 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 4:05 PM
Points: 1,514, Visits: 720

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

Carlo Romagnano

Posted Tuesday, December 29, 2009 12:54 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:04 AM
Points: 1,968, Visits: 1,819

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

Herman van Midden

Posted Tuesday, December 29, 2009 1:01 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:02 AM
Points: 324, Visits: 181

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. Angry

Herman

Post #839722

Robbert Hof

Posted Tuesday, December 29, 2009 1:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:01 PM
Points: 1,282, Visits: 743

The QotD needs a Moderator !!!

Post #839727

vk-kirov

Posted Tuesday, December 29, 2009 1:24 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 12:59 AM
Points: 3,188, Visits: 4,141

I clicked on the link...

Ref: http://support.microsoft.com/kb/811008

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

Bhavesh_Patel

Posted Tuesday, December 29, 2009 2:43 AM

SSChasing 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 .. Tongue

Bhavesh Patel

http://bhaveshgpatel.wordpress.com/

Post #839742

Daveee

Posted Tuesday, December 29, 2009 4:01 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:39 AM
Points: 700, Visits: 1,005

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

sjimmo

Posted Tuesday, December 29, 2009 6:33 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:51 AM
Points: 2,862, Visits: 2,465

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

webrunner

Posted Tuesday, December 29, 2009 8:21 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209

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. Tongue

- webrunner

-------------------
"The chemistry must be respected." - Walter White

"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

timfle

Posted Tuesday, December 29, 2009 8:37 AM

Say Hey Kid

Group: General Forum Members
Last Login: Thursday, February 02, 2012 4:08 PM
Points: 708, Visits: 87

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 »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions