hmmm.... not quite sure you're right there...

Yes the passive node would be exactly that 'passive' and as such you're right in saying that it wouldn't...

So, what do you think, a genuine newbie or someone with an assignment they need to have answers for?

It's farily obvious that they've never used SQL before. Maybe we should...

No doubt 500+ occasions where you could have used one but chose not to

Lets not be too hard on him, we were all newbies once and it's fairly obvious he's just starting out (or needs to find out for an assignment)

Good question .  As far as I'm concerned cursors are of no use whatsoever (in 99.999% of...

I agree with not restoring the master database, the new install will have one and unless you're on the same service pack and have the files installed in the same...

No Problem Viking,

I'm glad I could help

If it were me i'd start by doing the immediate full backup to disk, then supliment this with 4 hourly transaction log backups (for peace of mind) and nightly differential...

It sounds like you're in a bind with that server, for the migration to the new one i'd leave backup exec alone and use SQL backups to disks to do...

Hi Richard,

The best way for you to do this is to utilise your backups and restore each DB on the new server, I know this means a little extra work because...

Hi Viking, We're also looking at implementing this setup in the very near future, the highlighted bit in the text simply says that you should configure the passive node explicitly...

If you have a look at the Stored procedures in the MSDB database you'll find one called sp_update_jobschedule, there's a writeup in BOL that explains how to use it properly

I'm sure that I've read before that the example of the in BOL has a bug, if your change fixes it then good for you.

I don't know, what type of DBA are you when you can't give me what I want before I know what it is ...

Oops, sorry I forgot to check back to see if anyone had posted a reply about this one.

Steve's right in what he's saying but remember to do it as the...