No. The SQL Server service runs under LocalSystem. Do you think that could be the problem? I wouldn't think so.

No I didn't. My understanding is that it would use the default restore paths for the secondary instance.

Perry Whittle (9/22/2012)

---

Get back to basics, firstly the agent service account on the primary doesn't need any access to the copy location on the secondary server. It doesn't know about...

I attached a jpeg screenshot. I apologize for size ration, but you should be able to zoom in and scroll over.

Essentially, the error occurs upon completion of the wizard when...

Yes, sorry. I did those as well. For the sake of testing, the account has full permissions under both tabs, and is the service account used for the SQL Server...

Yup, that turned out to be exactly what I was looking for. Worked like a dream.

Excellent! Thank you.

Thank you for your help. I have removed mirroring. I will watch and see what, if anything, this does for the full backups as well.

Thanks again for your help!

Tom

Yup. I saw that in the link you posted. That explains why the log is not being truncated for certain. Does that also explain why the full backups are nearly...

It is not being log shipped, but I do have mirroring configured, though it has been suspended for some time.

This is a great alternative to setting up mail notifications on jobs without using SQL mail. It does have some limitations, but for failure/success notifications, it's great. And it's way...

I don't necessarily need to reclaim all the space. But it's an 12 Gb db with over 140 Gb of unused space. And the table that was using all that...

That is a great tip. And it worked to some degree. Where there was 221 Gb of available space, now there is 141 Gb. Is it safe to repeat that...

That's a good idea. Thanks for your help.

Any good free tools out there you can recommend that I can play around with?