Create Window Service to take sql database Backup

Question

Hi friends I want to create window service which will take up backup after 1-1 hour & delete the existing same name backup file. I am doing the same using the Sql Maintenance plan.which is working properly. Only issues is i can not delete before 1 hour backup with new created one. Whcih increases space of hard disk regularly. So can this possible.

Pravin Ghadge · Answer

Thanx for ur reply. I dont understand .net utility. r u talking about .net program. If yes then plz give me some idea how should i run automatically this utility without running the application. Regards Pravin

Suthish Nair · Answer

Why try like this way.. After your SQL MPlan completes run an .net utility which checks for today's file. If file found delete the other one.