Could any one tell me, what will be the query to delete the old backup file from a network location and store the backup in the same network location.
If you want to delete a disk file from T-SQL you will need to use the xp_cmdshell command. You can create the scripts to delete the existing files and copy the new files yourself, but perhaps an easier option would be to use the maintenance plan wizard in SQL Server. You can access maintenance plan wizard from SQL Server Management Studio after connecting to the server and opening up the Management -> Maintenance Plans node in object explorer.
You are absolutely right, but here we want to access the drive over LAN i.e., network location.
You can create network drive and can use it in xp_cmdshell
Please refer the link: