Superb Jeff, also is there any similar command for copy the files?

Thanks much, what is the alternative for reading the file from sql if i dont want to use xp_cmdshell , i am using below

--Selecting all the backup files from backup...

Thanks all, any idea what maintenance cleanup schedule uses in SQL server to clean up back up files?

Thanks everyone ,appreciate your replies.

another question is ,i am usin xp_cmdshell to delete the old backup files , and for that i need to make a change on all servers...

thank you , i was trying to use cast but that did not working , thanks again

Thanks ,but it did not work out as separate delete

-- separate delete works fine

--Remove all the diff backups from delete cmd

Delete from #ExistingBackups where...

i am using T-SQL script to take a backup and then delete the previous one as of now ,and getting budget approved might take more time and database i am...

nevermind ,found the issue ,it was quotename causing issue , thanks again for the help.

Awesome , also while trying to do the same i am stuck in string manipulation for @datestamp and with below it is always giving two quotes ,any way to get...

some body suggested ,through select statement , but i was looking to make it simple where first delete statement results pass on to further delted , i can do that...

yes that is what i am looking for as i could not get pass through the same result OR clause , any idea how will it look like to get...

Thanks , Yes i have couple of servers on SAN , what other utilities you refer?

what is the best way to get the production IOPs requirement , we have ETL that runs for an hour and trying to get new H/w , what is the...

Thanks , how is the performance hit after enabling this ? also did you consider server side trace performance comparion with audit function?

perfect ,thank you