Viewing 15 posts - 241 through 255 (of 322 total)
Thanks for the link. Lots of interesting stuff on there. Not found exactly what I need yet but I'll keep looking!
March 18, 2009 at 5:00 am
Well its SP2 off the Microsoft site. Its the x86 version (as I'm on a 32 bit machine). I have already installed the 64 bit SP2 on the actual SQL...
March 17, 2009 at 4:57 pm
Excellent. Works like a charm. I had tried this already but made the mistake of switching the existing Flat File connection from Fixed Width to Ragged Right. For some reason...
March 17, 2009 at 9:55 am
Does that property mean that it will keep the object intact and only ADD the data from B, and NOT remove the already populated data?
Also is that normal behaviour when...
February 23, 2009 at 9:38 am
Method I have gone for (If anyone else can think of something better be great!)
Set up Pull subscription From Server A to C with snapshot to start it off.
BCP data...
February 23, 2009 at 6:19 am
no no think of it like this.....
Option A
I put the subscription in place. Log reader starts building up transactions.
I bulk copy the data from Servers A and B and put...
February 20, 2009 at 3:43 pm
No the primary key ranges are different on each. Its 2 different sources of data within 1 table structure at the destination end.
If I turn the distribution agent on...
February 20, 2009 at 9:27 am
Yes but why fail? On SQL 2000 it runs as successful but with errors skipped. Skipping errors is not really dangerous when you are expecting them and on a temporary...
February 20, 2009 at 8:58 am
Thats brilliant (both answers). Thanks!
Another side question - When you are trying to get "continue on data consistency errors" on from 2000 to 2005 - how does this work? I...
February 20, 2009 at 4:36 am
Just FYI I solved this. I did not script the Distributor side just the subscriber side, hence the problems. All ok now.
February 8, 2009 at 3:47 pm
Actually I think it may be trying to resync everything. DO NOT NEED it doing that. I thought I'd turned sync off in the script, am I missing something?
use [LIVEDB]
GO
exec...
February 8, 2009 at 3:02 pm
Hi people. An update....
It turned out back the other week that the Distribution database was taking up all the back up time and holding life up. The reason the dist...
January 27, 2009 at 9:07 am
Thanks for the tips.
Thing is though I am taking log backups every 10 mintues 24 hours a day!!
January 9, 2009 at 8:18 am
Massively oversized, but they do use a process that builds up the transaction log a great deal. To save time on the backups is it worth scheduling a shrink each...
January 9, 2009 at 7:34 am
Viewing 15 posts - 241 through 255 (of 322 total)