Thank you all for your advices.

I think I solved it. It was a security issue. Even if my windows account had full access to those 2 drives and the xp_fixeddrives...

No, they are not mapped. They correspond to physical drives connected to the system.

Yes, I can understand this and I don't expect the CDROM to be inlcuded in the result set. But I expect to see the fixed drives H and T and...

Basically, there are 3 things here:

1. Allow users who are not sysadmin to execute (SQLServer Agent/Job System/ Only users with SysAdmin privileges ... UNCHECKED);

2. Have a proxy account with all...

You must grant explicit execute for that user:

GRANT EXECUTE on xp_cmdshell TO <your user/group>

Thank yoy, Wise Guy. This helps a lot!

Thanks, I tried, is not working.

Is there any way to control how much will go in the first file and how much in the secound? For a really big database how big will be each...

Thank you, Edward, I will try to do it this way.

However, I am not sure I have the same problem. I have only checked the box for "Include indexes", and not...

Yes, I can run the DBCC CHECKDB and gives no error.

In the SQL Server log I only see that the job failed. The"General network..." is shown by the Job...