was the db that you restored replicated? you may want to try sp_repldone

They do but it is not very robust and i would not consider it an enterprise solution. It would also be nice if it was integrated into the gui.

I am interested to know which software does a better job offering enterprise like functionality. In particular do any of the tools offer an interface for SQL Log Shipping.

I could be wrong but that sounds like an smtp error message. You should check with you exchange admin to see if everything is configured to allow you to send...

Try running a dbcc shrinkfile command after the log is truncated. if you specify truncateonly that will release all of the empty space back to the os.

From BOL

DBCC SHRINKFILE...

I agree. What does easiest mean. What is the upside by using the server network utility? What is the downside of using EM. From my perspective it is better and...

Just wondering... Why are you doing this through a stored proc.

That is a good question. Let us know when you find the definative answer.