Viewing 15 posts - 1 through 15 (of 16 total)
Now you are sprouting wisdom!
I have done exactly that! Created multiple transactional publications on the database with the largest tables being placed in one publication. Now if I...
November 11, 2008 at 6:55 am
Ha ha! I love hearing people tell others to read books on-line. If all the answers were there we wouldn't have forums like this!
Okay - so...
November 10, 2008 at 11:27 pm
Hi thanks for the Responses!
Dick - can you tell me what the @schema_option = 0x00000000080350DB settings turn on?
Noel - The -skiperrors is a work around, and definitely...
November 8, 2008 at 1:07 am
Hi all,
I have a very interesting SS2K vs ss2K5 problem, which I am currently bypassing in hope of a solution.
My topology:
-1 publication database in SS2K (600GB)
-1 SS2K...
November 7, 2008 at 12:37 am
Thanks for the heads up!!! I never checked the date!!
June 15, 2007 at 3:30 am
Hi All
I am having a very similar problem. I have a very large database that is being replicated using one way transactional replication. I replicate this database to two totally...
June 14, 2007 at 9:43 am
This maight help. Bare in mind that Windows security should be utilised above Mixed mode! Windows/SQL security can be defined by the following list (which...
March 20, 2006 at 3:56 am
HI Larry, we have a similar situation - we have used transaction shipping to (in your case) the local server. The shipping log is implemented by the production server's maintenance...
January 26, 2006 at 7:57 am
Hi
There is much debate on optional Optional parameters we have a VLDB with over 50000000 records. Based on the condition shown above we have found the following optimisations:
January 18, 2006 at 7:48 am
Shutting down SQL is easy, it is shutting down replicated servers in sequence and then starting them up again - that is an art! If anyone has a process /...
November 17, 2005 at 8:23 am
Yes - that’s exactly what I mean. I have checked the tables that we are trying to replicate, and I believe these tables were designed without replication in...
September 22, 2005 at 9:05 am
Hi Homebrew01,
We have about 600 tables. 12 of these tables are over 10Million records in size, and yes it is transactional. The business requirements are two fold, firstly to...
September 22, 2005 at 12:07 am
Whoops - Sorry about the double post!!!
September 21, 2005 at 12:33 am
Hi there, We have had numerous problems. Firstly to tell you a bit about our environment. We have a 100GB MS-SQL2K SP4 database which we are trying to replicate to...
September 21, 2005 at 12:32 am
Hi there, We have had numerous problems. Firstly to tell you a bit about our environment. We have a 100GB MS-SQL2K SP4 database which we are trying to replicate to...
September 21, 2005 at 12:32 am
Viewing 15 posts - 1 through 15 (of 16 total)