Loading

Create Window Service to take sql database Backup

Pravin Ghadge

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin Ghadge15y ago
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 Nair15y ago
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.