Is there a backup file named "May10.bak" on C: drive? If yes, do you have/ account have enough privilege to access that file?

Also make sure that your analysis have not excluded Foreign keys. Because lot many scripts available online do not consider FK while doing unused Index analysis.

I do agree with...

What is the state of database in secondary server? If it is in Standby mode, have you checked the Checkbox "Disconnect uses in the databse when restoring backup"

Use sp_send_dbmail to construct desired subject lines and use that a part of job to send alerts.

SYS.PROCESSES or SYSPROCESSES?

He can use roll up to get the bottom total too like below but I am not able to sort it right as he want based on Grandtotal.

SELECT [SlNo#] =...

You can not get your space back on that way.

The only way I know is that you have to restart SQL server services. But You really have to read...

Try to figure it out why you even can't ping that IP from command prompt.

If you can not ping it, SQL cannot validate it.

What does "want to keep 30 iterations of it" means?

You want to run it daily 30 times? Loop through it. Or save results of 30 iterations of job?

Have you tried restarting SQL with two trace flags as below.

SQLServr.exe –T3608 –T3609

Also here is an artcle from Gail Shaw which explains this in a really good way.

https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

If queries are running fine in Query analyzer but not in application, I suspect two things.

1) Parameter sniffing

2) Network latency

Try to work on these 2 things and see what you...

I think you should use Table Valued Parameter. The below link has examples in it too.

http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/

Have you even tried it? If yes, what values you have passed? Waittime is value passes in millisecond so you have to convert hours in ms.

The only way I know you can set up a replication by creating a snapshot or initialize with backup. In both cases you have to have the same schema...

Does the account/ SQL Server agent Service account has delete file permission on the server where job is set up?

Try logging in the folder with the account which is running...