DOH!!!

Hey,

How did you get on? I'm doing basically the same thing.

Regards,

D.

Hi Gail,

Maybe I have it wrong (most likely), but I wondered if the gentleman configuring the server for AD-HOC queries might help in this situation?

Regards,

D.

Hello,

Yes, I had to drop both the subscription and the publication, once done the logs were freed up and I was able to shrink and empty the file. Not a...

Hello,

I tried this but inserts into the table at the publisher are not replication to the subscriber. In my view this does not work.

Regards,

D.

You have 3 SQL Instances lets call them A, B and C.

Instance A and B are on the same network, instance C is on another network.

The instances are configured as...

ignore

Hello,

It sounds like from your description that the staging DB will either have all the data as it stands in the live database but only for the tables you want...

Hello, again thanks for getting back, yes your right it is 2008, I had just read about the CDC splitter and you are of right, its for 2012.

Where will the...

Hi Jeff,

Thanks for the response, well the third databases/s are not on the same network, the script with the updates has to be sent to them and applied when they...

Hello,

I got a slightly more up to date version of what it is I need to do.

I need to take the latest changes out of a SQL database and put...

Thanks Mohan, that helped me out.

Regards,

D.

Hi RTaylor,

Thank you for responding, an interesting path to go down, I believe all the tables will be static when the comparison is made, but change every month. With the...

Hello,

Yeah Red Gate have great tools, but unfortunatly I'm not in a position to buy those kind of things. Thanks PJones I'll look into the table diff and see if...

OK, so basically I ended up backing up the database, moving it to secondary, restoring the database in NoRecovery/Stand By, and went back to the primary and finished log shipping...