why do you think the log shipping needs same versions of sql? Is it for the same reason?

I'll tell you why we want it - from your explanation seems like we are good to go with that.

We need to replicate a database from one site to another...

yes that almost worked.

I created the function on the subscriber then I got a new error about not being able to drop the PolicyDocument table. The issue was that the...

Thanks,

I did see that microsoft article while researching the issue.

After getting some support from microsoft about this issue. They had a look and said it was probably due to...

thanks - I took your advice and got the boss to fork out the cash. Just waiting on microsoft to get back to me.

Is your log shipping server in the same office as your primary server?

If so you may need an offsite backup in case of flood, fire, terrorist attack.

after about 5 months the boss signed off on licencing for sql 2008 R2 last week. Should be able to install the licence for expiry date next Saturday!

thank for your...

I'm sure they will! 😀

nah - need the report server and analysis services.

yes it is a production server. I been on management's case for several months about buying a licence.