数据库作业备份

数据库作业备份

var sql = string.Format(@"DECLARE @strPath NVARCHAR(200)
            set @strPath = convert(NVARCHAR(19),getdate(),120)
            set @strPath = REPLACE(@strPath, ':' , '.')
            set @strPath = '{0}\' + @strPath + '.bak'
            BACKUP DATABASE [XuChangGov_Pub_DB] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT ",
            HttpContext.Current.Server.MapPath(WebConfig.GetKeyString("dbCopy")));

            var dct = new MyDataContext(WebConfig.GetSqlConnectionString("Conn1"));