Quartz定时备份数据库

数据定时备份，相关的数据表只有一个，请执行sqlserver创建 即可

using SQLQuartzBackups.Untities;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Management;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace SQLQuartzBackups
{
    public partial class Form1 : Form
    {
        public Form1（）
        {
            InitializeComponent（）;
        }

        private void button1_Click（object sender EventArgs e）
        {
            bool status = false;
            string filepath = ““;


            //连接共享文件夹
            //status = connectState（@“\\dechang.kin.net“ @“kin\wanghaidong“ “123456“）;
            //直接用IP也可以
            status = connectSt

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

    ..A..H.     95232  2020-03-12 22:50  SQLQuartzBackups\.vs\SQLQuartzBackups\v14\.suo

     文件       9483  2018-10-15 00:46  SQLQuartzBackups\packages\log4net.2.0.8\.signature.p7s

     文件     278528  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net20-full\log4net.dll

     文件    1482763  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net20-full\log4net.xml

     文件     282624  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net35-client\log4net.dll

     文件    1537338  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net35-client\log4net.xml

     文件     286720  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net35-full\log4net.dll

     文件    1547797  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net35-full\log4net.xml

     文件     274944  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net40-client\log4net.dll

     文件    1537338  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net40-client\log4net.xml

     文件     275968  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net40-full\log4net.dll

     文件    1547797  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net40-full\log4net.xml

     文件     276480  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net45-full\log4net.dll

     文件    1547797  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\net45-full\log4net.xml

     文件     221184  2017-03-08 19:26  SQLQuartzBackups\packages\log4net.2.0.8\lib\netstandard1.3\log4net.dll

     文件    1760575  2020-02-17 18:36  SQLQuartzBackups\packages\log4net.2.0.8\log4net.2.0.8.nupkg

     文件       1457  2020-02-17 19:25  SQLQuartzBackups\SQLQuartzBackups\App.config

     文件      39424  2017-08-30 12:36  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\Common.Logging.dll

     文件         39  2020-02-17 18:55  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\Config.ini

     文件     276480  2017-03-08 19:26  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\log4net.dll

     文件    1547797  2017-03-08 19:26  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\log4net.xml

     文件     946176  2017-08-30 12:36  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\Quartz.dll

     文件    1777152  2017-08-30 12:36  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\Quartz.pdb

     文件    1028016  2017-08-30 12:36  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\Quartz.xml

     文件      57856  2020-03-12 18:46  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\SQLQuartzBackups.exe

     文件       1457  2020-02-17 19:25  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\SQLQuartzBackups.exe.config

     文件      91648  2020-03-12 18:46  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\SQLQuartzBackups.pdb

     文件      22688  2020-03-12 18:37  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\SQLQuartzBackups.vshost.exe

     文件       1457  2020-02-17 19:25  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\SQLQuartzBackups.vshost.exe.config

     文件        490  2018-09-15 15:29  SQLQuartzBackups\SQLQuartzBackups\bin\Debug\SQLQuartzBackups.vshost.exe.manifest

............此处省略84个文件信息