Cheers! haha. Works now.

Yeah they are. I'm really confused!

Its on SP3 onwards.

Thanks for your help peeps. I'm piecing it together.

Ok folks nothing to see here. Move along....

(I'm a fool)

Basically I misread the sizes. I'm a fool! Ignore me and this. I'm not normally an idiot.

The database files are currently only 6gb including MDF and LDF. Do you mean they were ORIGINALLY set up as xgb? That's new to me! They have been shrunk down...

Cheers! I sorted it on the day, and dropped and re-added the subscription as you rightly said.

Well it seems to be switching between HTTP and HTTPS when it supposed to be all HTTPS so i think it may be dropping sessions. The errors occur randomly, although...

How can I get the job keep doing a retry though? It seems to give up after 10.

Hmmm any clue on getting aliases across?

SQL crazies! Stopped the script, re ran it - 10 seconds! The 30 minutes was a sham!

Most of my headaches have been between 6.5 and 2000 I must admit. This seems more straight forward!

Cheers

(However, I am running my script on the new server and it has...

I did stop it and rerun as a job in the end. Took 4 hours!

Cheers

Ah no! I've stayed late in the office and its done an hour and a half already. If I cancel now all my work will be ruined! I need to...

Thats the baby! Thankye very much.

I feel like count(*) on a table of 8 million records and 499 other tables of varying sizes up to a million would not be...

The data, keys and what not are all fine on the data entry db. This is the reporting db where the data will not change. Just so you know.

Thanks for...