yes sir i use that, but the problem is every-time the backup run another file-name created. so i need to edit the sql agent to rename the backup file name.

sir i want to automatic restore the backup files using sql agent, how can i solve this using sql agent automation