Viewing 15 posts - 16 through 30 (of 1,790 total)
In that case you should be able to rename the server following bringing it back online. I have done this and it does work, even for the distributor.
The big...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 18, 2013 at 11:51 am
Sorry, I don't. I haven't really used mirroring at all and so am very weak on this subject. Just so that I understand better though, what is your goal that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 18, 2013 at 11:28 am
Yes, agreed. That is a bit troublesome to sync, though not impossible. Having a synchronous mirror for the distribution server would be helpful. I definitely recommend having a HA solution...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 16, 2013 at 10:59 am
The difficulty you face is that the LSN for the replicated transactions in the distribution database are out of sync with what you have coming from the publisher. The error...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 16, 2013 at 10:06 am
Having multiple publications per database isn't really a nightmare. Definitely forces you to use the metadata tables a bit more but nothing too difficult.
Anyway, glad you found a way...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 16, 2013 at 7:14 am
In the publisher database is where you will most likely have the issue here. I would rebuild all the MS* tables, even if they don't get too fragmented. You could...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 12:33 pm
Ok, a more serious reply than my previous one.
Honesty is critical here. You can't make it about a person or that becomes a conflict. You can make it about...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 9:19 am
It is a fine idea and a frequently used solution. I would recommend that you use transactional replication. To begin you will need to figure out what tables are needed...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 7:54 am
Heh - when I read the title of this post the first time I thought it said "eradicate" not "educate". 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 7:52 am
Have you rebuilt the indexes for the merge metadata tables? I have seen those cause some really odd issues in the past.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 7:50 am
Scott Arendt (12/13/2013)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 7:49 am
Yes, you don't want to skip the error or it will just not replicate that command and then the stored procedure will not be there, or would not be updated....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 7:34 am
And another good article - http://www.sqlskills.com/blogs/paul/tracking-page-splits-using-the-transaction-log/
And when you are done with that one if you want to read more on page splits and page allocations search Google for "Paul Randal...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 6:53 am
Anyone? Bueller?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 6:49 am
There is a way to bypass data dependencies, but not object dependencies, as far as I know. I can't think why you would want to, honestly. If you require...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 12, 2013 at 3:35 pm
Viewing 15 posts - 16 through 30 (of 1,790 total)