Viewing 15 posts - 1,546 through 1,560 (of 1,583 total)
What a nightmare making a phone call to Microsoft was...I can't even being to express how much the entire experience was a waste of both the time and money spent....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 14, 2011 at 10:27 am
If this is a production box I wouldn't reccomend switching anything to simple mode...just throwing that out there (as I'm sure you're already aware)
Without knowing the details (i.e. how large...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 14, 2011 at 9:58 am
Sounds like a school project 😉 That being said I doubt anyione in the forum will do it all for you...If you're tinkering with SSIS you should already know...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 10, 2011 at 1:30 pm
No. We had a full down at that point in time the diff was taken.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 3:19 pm
We're kind of in a bind here with our corporate reporting...I've opened a call with MS tech support - see where that goes...
🙁
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 12:29 pm
There is an additional snapshot publication that runs twice daily but that's wokring just fine.
I have 3 databases replicating (each with about 30 tables), each having 1-2 snapshot replication runing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 11:29 am
No luck...
I can't believe this is a problem after deleting the publication and subscriptions...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 10:52 am
On my production box, I opened up a new window/connection.
Ran sp_repldone NULL, NULL, 0, 1 (the defaults)
(it said it was successful)
Went to the Replication monitor, stopped the log reader agent,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 10:23 am
This is coming from the Log Reader Agent:
Error messages:
The process could not execute 'sp_repldone/sp_replcounters' on MyServer. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
The log scan number (193864:92424:1) passed to log...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 10:13 am
Okay, I deleted the publisher for the database I was replicating and the subscriptions on the other server.
Recreated the publisher and added the articles I needed and ran the job...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 10:07 am
Thanks for the quick reply. Do you have any idea how long the sp_replrestart should take? It;s been over 15 mins already and still going.
I am beginning to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 9:25 am
I've also had good experiences using EXCEPT, as long as you've got some decent indexes on the table you're hitting.
INSERT INTO Local.Table
SELECT col1, col2... FROM Remote.Table
EXCEPT
SELECT col1, col2... FROM Local.Table
This...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2011 at 3:44 pm
You could try adding a column to the end of the remote table that has a default value of GETDATE so as records get added to the remote table, they...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2011 at 3:36 pm
I am facing a similar issue. I usually do my own custom logshipping but with this particular project (attempting to logship from '05 to '08 with the '08 DB's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2011 at 3:25 pm
Hey thanks for the reply!!! I realize you can use the NORECOVERY option but that keeps the DB in a mode where we can't test anything as the DB's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 1, 2011 at 9:31 pm
Viewing 15 posts - 1,546 through 1,560 (of 1,583 total)