Thank you both for your contributions, I think I have a better understanding now!

As I understand, when the Simple recovery model is used all committed transactions are removed from the transaction log. In this scenario there would be no point in backing up...

Hi Keith,

So assume I had a Root level with two intermediate levels each having three leaf level nodes in my clustered index. If I delete a load of rows that happen...

Hi All,

I think Jeff is right, no idea how I came up with my original figure of 16Gb. I am going to recalculate my other tables now!

Thanks to all for...

Sorry, still confused because the amount of space used by the database as a whole is 6Gb but my calculation does not fit with this.

The table has 31 columns of...

Hi,

Our 1st week of the year started on 2nd Jan until 8th Jan which is why 29th Jan is our week 4.

Thanks

Hi Marco,

My server already had sp4 installed but I found that re-installing the sp cured the problem. Thanks for your help.

I tried setting the other server up as the publisher, distributor and subscriber. When I tried to create either a push or pull subscription I got the following message:

Error 14053: Cannot load...

Hi Graeme,

The 'DROP exisiting table and re-create it' flag has been set. I've run through the steps again but still cannot get it to work. I set one server up...

Thank you both, works perfectly.

Regards

Hi Kory,

Please can you explain how to this?

Thanks

Hi Graeme,

The two servers are on the same network and each server is able to register the other in EM. I have tried disabling publication and distribution on the one...

The replication type is snapshot, I don't have access to the server at the moment but yes, I believe the error is in the distribution agent.

David

Hi Graeme,

I configured one server as the distributor and then configured it as the publisher. The second server was then added as a subscriber. I ran the snapshot agent and...

Thank you, I'll give that a try right now.