I think I figured it out and it's something interesting that I didn't know about Database Mail. The SQL Server Agent Operators let you specify multiple email addresses per...

Yes. We tried recycling along with failing to the second node (K: still not accessible) and back to the first node (no change).

Depending on the sizes of your databases, you may want to look into zipping each backup file individually. For larger databases, back them up in smaller chunks as it'll cut...

My guess is that bcp isn't liking your WHERE clause. Either the quotes are throwing it off or just in general, it doesn't like to process a query with...

Nevermind. I found out that because it's a FAT32 format, the largest files it can have are 4 GB, which the bak files that I'm having problems on are all...

Because of all the heinous joins and unreadability in the second query, I'd recommend taking both query results and throwing them into session temp tables first. It'll make your final...

Can you post an example of what these files look like?

Also, why in the world would they insist on doing batch files for the database backups instead of something that...

You can use xp_cmdshell and bcp.

More information here:

http://msdn.microsoft.com/en-us/library/ms162802.aspx

In your case fora csv, you'll specify that the -t (field term) will be a comma, which it'll add that in...

Couldn't that be done too via a SQL Agent job that runs every say 30 minutes or 1 hour? Just periodically look to see if there is a file...

Try and restore the backups on that machine. If that doesn't work, do you have another machine you can try and restore the backup onto?

Don't forget to change the...

The MDF is the data file, not a backup file. I'm guessing you're trying to see if you can reattach the database with just the MDF file?

Take a...

Can you reboot the computer?

Depending on your I/O needs too, SQL Server can be a bit of a resource hog. If you have SQL Server 2008, you can use Resource Governor though to...

Can you see in the Report Manager screen where it thinks the pathnames are to the report files?

I'd go with dynamic sql also. Easier to debug too if something goes wrong (in my opinion).