Viewing 15 posts - 2,656 through 2,670 (of 2,897 total)
Is it a pull subscription running at the subscriber ? I just modify the SQL agent job on the subscriber to use email notification when the job fails
October 11, 2005 at 9:50 am
Sounds as though the snapshot job at the publisher has never run, so it can't be sent to the subscriber.
October 11, 2005 at 9:48 am
The most frequent setting for a SQL job is every minute, but if you choose a "contimuosly updating" subscriber, then the SQL job is "never ending" so it's running all the...
October 11, 2005 at 7:45 am
If you don't want a snapshot applied at the subscriber, just choose "schema & data already exist". The Stored procs are used afterwards to apply published transactions to the subscriber. ...
October 10, 2005 at 7:26 pm
Are you talking about spring or fall ?? I think both are going to be adjusted, but by different amounts.
October 10, 2005 at 2:54 pm
I don't quite follow what your question is. I use the default MS SPs during replication, but I can imagine that if I wanted some custom tasks to run instead...
October 10, 2005 at 1:00 pm
Could you explain a bit more ? Which logs ?? The distribution database can grow large, based on your retention period setting.
October 10, 2005 at 12:55 pm
Phil, what do you mean by " .. Also, the minimum interval for replication is 1 one minute."
If you choose a continuosly updating subscriber, then latency is only a few...
October 10, 2005 at 12:23 pm
Your hardware and communication will have some impact, so you can't get an exact answer here. I wonder how you could measure it ? Perhaps set up a test replication,...
October 7, 2005 at 11:53 am
Is that table in the same publication as other tables, or is it in its own publication ? Are other tables missing data ? Did you create the publication, but...
October 6, 2005 at 5:35 pm
Could you explain ? I don't quite follow what your problem & solution are ? Where's the bulk insert flag ?
October 5, 2005 at 3:22 pm
I think you get the data since the subscriber was created. Set up a little test replication of a small table & try it out.
October 5, 2005 at 3:05 pm
If I understand you correctly, than these comments come to mind:
" ... Recreates snapshot daily at 4 am. ..."
If you're doing transactional replication, you only need to run the snapshot...
October 5, 2005 at 3:02 pm
I did this with good results when I needed to change the length of a field in a replicated table. -- Specifically: Drop a table from a publication so...
October 4, 2005 at 9:37 am
Good points. I found this article about default DB, and the follow-up discussion at: http://www.sqlservercentral.com/columnists/awarren/settingadefaultdatabaseforyourlogins.asp
The consensus seemed to be to either use tempdb as the default, or set up...
October 4, 2005 at 8:36 am
Viewing 15 posts - 2,656 through 2,670 (of 2,897 total)