Viewing 15 posts - 16 through 30 (of 1,789 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...
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...
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...
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...
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...
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...
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...
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...
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". 😛
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.
December 13, 2013 at 7:50 am
Scott Arendt (12/13/2013)
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....
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...
December 13, 2013 at 6:53 am
Anyone? Bueller?
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...
December 12, 2013 at 3:35 pm
Viewing 15 posts - 16 through 30 (of 1,789 total)