how to create a Sql server database backup file in C#

Hi Ravi,

If you have a shrared server and you have access to it then you will find how to create a Schedular task find it. Put backup script in it and set Event to end of each month.

If you have dediated server login to server and do same from control panel.

Its the easiest way to do what you want. We have lots of sites in dedicated server we have done same for every db automatically which runs at 11:50 at night.

Hope it helps.

Thanks.

Ranjit Powar10y ago

I think code will remain same. Only difference is you have to change the local server to your web server.

Ravi Patel10y ago

Hi ,

thanks for your reply .

but i want to do in web application not in window app

Ranjit Powar10y ago

Check this

http://www.c-sharpcorner.com/Blogs/15749/take-sql-sever-database-backup-from-winform.aspx