did you do any test connectivity ? does it work?

Nice one. As soon as I saw option #3, I selected and scored 2 points.

thnx for all your response. I'll better check the status of the first job using sysjobhistory and use that value to the other job. Thnx Indeed. Bye

Any update by anyone?

HI Jeff,

Is this possible to club the details of all the folders/files if one mentions any location/path???

This one is only working against files and a v nice one as it...

Ohh...great. thnx.

May b the best accurate guess.

Thnx Lynnnn... have a great weekend..

Filtered indexes are defined on one table and only support simple comparison operators. If you need a filter expression that references multiple tables or has complex logic, you should create...

I wrote it keeping in view of sql 2012, as I dont have 2014.

However, thnx for modifying it for sql 2014. Nice job.

Thnx for asking the question.

I have written to get the backup location first, then running delete command to only delete files from the location(backup Path) which has .bak as extension....

Does you car still make noise now? Lol...:-P:-D;-):-)

I found something v interesting. I am extracting the backup_path value using XP_INSTANCE_REGREAD.

If the value return with "\" at the end of the string then only the forfile command fails.

Now...

Tried using this, same error:-

exec master.dbo.xp_cmdshell 'forfiles /P "D:\BACKUP\" /s /m *.bak /d -3 /c "cmd /c del @PATH"'

Nice basic question.....Thanx. Scored 1 mark.

Index works like a double edged sword. It helps in retrieval operation when you run SELECT but at the same time it increases time if you are trying to insert/update/delete...

Nice One