I've used Netbackup and Commvault.

used to backup a 6TB database via netbackup to tape. Took 2-3 days for LTO-4

Commvault is nice and has amazing compression. Way...

you can try distributed replay controller. It's part of SQL 2012 and you might be able to use it with 2008 as well. It's more for load testing, but might...

Personally I like Extended Events better than profiler. But my biggest complaint is not setting up the session, but changing it. It was easier on profiler than editing the query...

Why would anyone run any other application on a SQL server? Especially one with large databases like this?

I've had really good results with lock pages in memory. I've...

I've had this happen via a straight SSMS connection from my computer and have seen something similar with replication. A few times the DC was hosed up and needed a...

create a variable
write a query to populate it 
write if statement if it equals doesn't equal 192 then Sp_send_dbmail with whatever you want to email

maybe put the...

Has anyone done this on servers with numerous applications accessing them? How do you handle applications slowing down due to the loss of indexes? And how does Always On react...

Is it possible to create a distro list on your email system with all the addresses who need this report and use it in your subscription? Fairly sure that this...

We use Commvault. I have a few scripts that check backupset to make sure everything is backed up. We do test restores every so often and Commvault verifies that the...

Commvault and a lot of the other disk backup systems you can replicate your backups to a DR site unlike native backups

could be DNS. For some reason it can't connect to the database.

Was SQL restarted during the error?

Not 100% sure but this might work

Entity Framework

And I'm not sure of the minimum version of SQL it requires

have you checked the requirements to make sure you don't need enterprise edition?

i'll try the elevated. I'm admin on the server and thought it would be enough