log shipping does work with sql 2005 standard edition.

this is IMHO the best solution for your A ---> B solution, but as mentioned before you will need to also maintain...

crystal drifts? is that like crystal meths?

my 2pence worth........

of course you need to know - how can you interprete results from perfmon counters like %disk time or avg q. length if you do not know the...

sounds like a good guess, certainly would fit the scenario.

clocks getting out of synch? over to an intel bod.....

Brian, sorry, nothing is jumpimg out at me. As I say I have only seen this when the job ran at the same time as the clocks going back and...

what does the job do? is it long running or a quick job, how is it kicked off?

I got exactly this run timing on a job that kicked off at exactly the time the clocks went back. Any differences in system time between the nodes. sounds like...

run sp_updatestats as well

do you know why it went into suspect mode?

you're best bet is likely to be restoring the database from a backup before the cause of the suspect status

Scott and steve, thanks for the replies.

Reassuring to know it will keep going. This must mean that the documents are referring to the principal not accepting connections if you also...

if you need to keep logins up to date on a constant basis in say logshipping then I agree...

If you have 60 odd databases to move and use SQL authenticated ids a lot you will have a lot of sp_change_users_login coding to do. (windows authentiacated users will be...

Lynn,

many thanks. looks like I have some learning to do with visual studio.

george

don't leave us in suspense, please post and share your solution.

I would have thought the simplest way though would be just to change the execution times of the sqlagent jobs...

A cluster for a monitoring server is WELL over the top. If you must have a seperate machine for this you can use any old PC with personal edition on...