Looks more like a port scanner running on your DB box. Or a service trying to identify all the servers in the network.

I just submitted my article for SSC so that Steve can rip it apart. 🙂

Thanks Johan and Jason for editing the mess and making it presentable. 🙂

IS the Database that you want to take Log back ups in FULL mode?

Can you check what is the plan difference when it is Select * vs Select column list? That should point you in the right directions.

Could you post the generic error you are getting?

Does it not show that there was an error in the SQL Agent error log?

Sorry if I am being stupid but why not just run sp_recompile for just that stored proc? It will recreate the plan.

Usually you leave 10 to 15% mem for the OS. In your case you have left 12 GB. That should be more than enough.

Do you have hyper threading enabled on...

Similarities, YES. But plagiarism NO. There are way too many articles about each topic that there is a chance that the...

Yep, we do just that. After the back up is completed, the same back up is restored in another DB Server, then it goes thru a scrubbing process to obfuscate...

I guess everyone has their own outlook of where the risk is when taking back ups. 🙂 I prefer going for network back up. I feel that it is bit...

The secure way to move data to Server OUT would still be replication. You can encrypt the data being transferred if I am not mistaken.

SQLRNNR (8/26/2011)

---

If you are looking to copy from the destination server, then setup a service that pings the sql service to check if job is completed every min, 5...

How would you let the Server that is going to initiate the back up know that the back up is complete?

Coping a 100 GB file does use quite a...

We currently do backup over the network. When we started backing up to the local disk, the page file usage started going high. Also if you want to use less...