Viewing 12 posts - 1 through 12 (of 12 total)
There is an option in the snapshot generation that 'Do not lock table'. Not sure if it work.
Does anyone use his option? and does it work? Checking this option, SQLServer...
April 25, 2006 at 3:30 pm
I don't think you can re-iniytialize an article for a PULL subscription. Check out the command line parameters. One can apecify Article in Push not in Pull.
Good Luck!!
April 25, 2006 at 3:18 pm
Below explans this counter: (<10 is considered OK)
Processor Queue Length is the number of threads in the processor queue. Unlike the disk counters, this counter counters, this counter shows ready...
March 20, 2006 at 3:08 pm
Check to make sure which file group the index(es) were created. That may be reason you don't see them in EM. (they are in a different file group).
Good Luck !!
March 20, 2006 at 2:56 pm
Extend your file group before loading large amount of data. Extending datafile during the loading process is very slow. For ETL, If the data require further processing, it is alway better...
March 20, 2006 at 2:50 pm
Check the profile in the publiscation database on the articles. looks like it is trying to re-create your articles (tables).
Good Luck !!
March 20, 2006 at 2:33 pm
What replication mode you are using - transactional or merge? Merge replication have to resole key value confict.
Good Luck !!
March 20, 2006 at 2:29 pm
If your users cannot tolerate more than a handful of minutes. Lomg ship is not a solution. I would consider the followings:
1. SQL Cluster locally (with disk mirroing etc) for High...
March 20, 2006 at 2:24 pm
Craete a user in the subscription DB with readonly access. Change the existing devloper access users' password. All developer should only have read-only access. The SPs have to update to...
March 20, 2006 at 2:18 pm
If one is implmenting applications for different client of similiar business and out them all in one DB. You are putting all eggs in one basket (single point of failure...
March 8, 2006 at 8:39 am
We are on 'Microsoft SQL Server 2000 - 8.00.2040.' (i.e SP4). I was not allow to post company scripts and schema without approval. We are using transactional replication without filtering...
February 8, 2006 at 7:49 am
Change the Query time out for the logreader's profile. default is 300 sec. Increase it to a value that stop the timeout error.
February 2, 2006 at 8:04 am
Viewing 12 posts - 1 through 12 (of 12 total)