I agree with Gaby. The day your backup fails is likely the same day your disk array will fail. Don't play around. Make sure these work locally and reliably.

I'm confused,if you have the service account connecting to SQL Server, how do you get the individual accounts to come through? Typically we set up for Windows auth, and IIS...

Now that got a laugh out of me! :hehe:

The questions are almost always built on the native tools unless noted.

your client tool will indeed translate things.

We are slaves to our own drive.

Or we used to be. Noticed my post count is dropping like the average knowledge of people coming to DBA interviews.

We're happy to help, but having all of these scenarios sounds more like an interview issue than one at work. I'm confused as to why you'd have tape and network...

Not to hjijack the thread, but Ed, do they really need that space?

Gail has a good idea, but I'm still not sure why you're afraid of a clustered index.

If one of the mirror backups fails, both fail.

Go with P Jones suggestion.

I certainly don't want more fans either. The SQLSaturdays have featured a scavenger hunt card, and I've been on a few, but it hasn't been too bad. We'll see in...

Ha!, you spar for real. I'm just an old geezer going through the motions.

Sure, far as I can throw you, which come to think about it, might be a good distance! 😛

I agree with Jeffrey. You buy a cluster to maintain uptime. Don't ruin that by experimenting.

Setup a separate cluster system, virtual if you have to, to test everything before...

I'd agree with Jeff here. If you have a 2008 instance, use that. If all you have are 2000 instances, then go with what you have.

If you use SSMS, a query is issued in the background.