...there's always a catch....

i just tried the 'MIRROR TO DISK' on a small database, I get an error message about mirror not being supported on this version of sql server....

Ho...

Something in my brain just went 'what?'

We currently keep the last 6 days of backups, so are you saying that the older 5 backups are worthless? - or is it...

OK - I think I'm adding to confusion, let me try to clear things up....

I'm currently using the SQL server maintenance wizard to do a database backup to a drobo.

I...

...also, I don't know how to add batch files to sql server maint plans, how do you do that?

...Won't that just make the backup copy go via the sql server - not speeding anything up?

Yeah, I currently use a xxcopy script to do this, but as the backups are on a drobo, I have to run the xxcopy script on a seperate machine, so...

Update....

I've fixed it - I set NIC 'a' with a static IP and subnet, then left the gateway and dns fields blank.

This was after I read an article about how...

...extra information I forgot to add....

If I disable NIC 'a', then I can connect using NIC 'b'. But as soon as NIC 'a' is re-enabled, I can no longer...