Ok great guys. Tricky one, lots to consider.

We have a meeting tomorrow with our hosting people (who suggested the Symantec route) and am looking for viable alternatives. Anyone have some...

Thats cool. Not a SQL question now but how would you control the 'heartbeat' - that controls which server is the live IP etc ?

So I could set up transactional replication between the two lives servers to keep them upto date. Allow windows clustering to deal with IP's etc.

That allows a failover at live.

Then...

Great stuff. Time for some reading before I start upsetting people.

Thanks again for your help.

I`m advising our mangement that upgrading is not the way forward as I don`t believe the application will work correctly. For example the concept of locking seems to have bypassed...

Thats great stuff. I`ll ensure that the relevant tasks get done. I have no belief that the suppliers would even understand what you have recommended !

Thats pretty much the configuration I was aiming at. But with a different port open for SQL.

I was called to jusitfy the reason behind ensuring the application was secure. The...

Thats great, explains whats going on.

Cheers for your help.

Text as requested.

03/03/2009 20:29:33,spid1s,Unknown,Server resumed execution after being idle 1791 seconds. Reason: timer event.

03/03/2009 19:44:28,spid1s,Unknown,Server resumed execution after being idle 1791 seconds. Reason: timer event.

03/03/2009 18:59:23,spid1s,Unknown,Server resumed execution after being...

See attachment

I had thought that. But there is no activity at all for 40 mins. The log goes from starting tempdb. Then 40 min gap, then starting next database.

Thanks for all the help guys.

I have altered the linked server to run off the sa password and it works fine. Not sure why it won`t map a login properly....

Yes I can connect from SQL2000 through to SQL2005.

How did you connect to the remote server? - I am using a linked server.

What queries you are running on the server? - Just doing a simple...

Good point ! I am running the query via a linked server. Have tried several times but to no avail 🙁

Will have a look at the link as well.