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

Question

Hi How to create Sql Server database backup file at the end of month through code using C# and keep backup file into server folder

Vishal Jadav · Answer

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 Powar · Answer

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

Ravi Patel · Answer

Hi  thanks for your reply . but i want to do in web application not in window app

Ranjit Powar · Answer

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