WEB程序SQLSERVER 数据库恢复与备份

  Math.DivRem(DateTime.Now.Day,2,out residiu);
   if(residiu==0) Name="Double";else Name="Single";
   SaveDir=SaveDir+Name+".dat";
   SaveDir=@"BACKUP DATABASE [crib2] TO  DISK = N'd:\20070717\crib2.bak' WITH NOFORMAT, NOINIT,  NAME = N'crib-完整数据库备份', SKIP, NOREWIND,NOUNLOAD,  STATS = 10";
   //SaveDir=@"BACKUP DATABASE [crib2] TO  DISK = N'" + path+"\crib2.bak' WITH NOFORMAT, NOINIT,  NAME = N'crib-完整数据库备份', SKIP, NOREWIND,NOUNLOAD,  STATS = 10";
   
   //SaveDir="backup database crib to disk='"+SaveDir+"'";
   //SaveDir=@"RESTORE DATABASE [crib2] FROM  DISK = N'd:\20070717\crib2.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 10";
   SaveDir=@"RESTORE DATABASE [crib] FROM  DISK = N'd:\20070717\crib.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 10";
   //string path = DateTime.Now.ToShortDateString();
   //string path =@"D:\"+DateTime.Now.ToString("yyyyMMddHHmmss");
   string path = @"D:\backup\"+DateTime.Now.ToString("yyyyMMddHHmmss");
   Directory.CreateDirectory(path);
   path = path + @"\crib.BAK";
   //SaveDir=@"BACKUP DATABASE [crib2] TO  DISK = N'd:\" + path  + "\crib2.bak' WITH NOFORMAT, NOINIT,  NAME = N'crib-完整数据库备份', SKIP, NOREWIND,NOUNLOAD,  STATS = 10";
   SaveDir=@"BACKUP DATABASE [crib] TO  DISK = N'"+ path +"' WITH NOFORMAT, NOINIT,  NAME = N'crib-完整数据库备份', SKIP, NOREWIND,NOUNLOAD,  STATS = 10";
   cinit.DBsubmit(SaveDir);
   Response.Write("<script language='javascript'>alert('数据库已经完全备份到D:盘backup路径下！');</script>");
   return ;