Thanks and yes they are using sp_executesql, so that's a good think

We are considering sql server virtualization and the major question I have is resource contention. If I have four virtual servers running then the all have to share resources and...

Thanks for the info. I agree, if I had written this, it would be all in one trigger. That way your not calling six different triggers to do an after...

I tried this on an enterprise edition and it keeps telling me that I must be on an enterprise or developer addition. Kinda strange. Thanks for your help though!

Thanks a million. I'll give it a try!

Thanks! From everything I have seen, that's about the only way!

I'm am now backing up to a local driver on the server and then xcopying the backups to our backup server and I'm not having a problem during the xcopy.

thanks...

Thanks!

yes I do have backups of msdb

It's the backupmediafamily table in the MSDB. I started getting backup errors. We use redgate backups. Because the backups were failing(and I believe its just one of the databases on...

yes, I checked the connectivity between server a and server c

here is my backup syntax. As you can see I'm pointing to two different servers. By the way, this is a active/passive clustered environment. I'm tryiing to set this...

Three years. I'll go to amazon.com, that's were I usually look for books. Thanks!

Thanks Steve!

I don't blame you for looking for other work. The telecommuting option seems to be a plus for everyone effected(reduction of dependency on foreign oil, the need for less building...