Thanks for your quick reply!

I just don't understand what the difference is between manually running the .exe file and invoke the .exe file from SQL Serevr Agent. As I mentioned...

Hi Adiga,

I have tried to use the method in the article you recommended. It worked. I have successfully removed the second log file. The only thing I need to do...

Thanks for your replies.

I assume to move the first log file, I need to detach the database, move the log files, attach the database back. But my concern is it...

I have the same problem. I have a scheduled job on a SQL Server 2005 that deletes some data on a linked server which is SQL Server 2000.

The weird...