用RAR备份源代码_用WSH备份数据库

用RAR备份源代码

 

@rem 备份源代码.bat path e:/program files/winrar rar.exe a -r -ag F:/ccenn_project/solution/source/backup/CcennSolution_ F:/ccenn_project/solution/source/CcennSolution/*.* @pause

 

用WSH备份数据库

//---------------------------- var oDate = new Date(); var sYear = oDate.getYear(); var sMonth = oDate.getMonth(); if (sMonth < 9) sMonth = "0" + (sMonth+1); var sDay = oDate.getDay(); if (sDay < 9) sDay = "0" + (sDay+1); var sHour = oDate.getHours(); if (sHour < 9) sHour = "0" + (sHour+1); var sMinute = oDate.getMinutes(); if (sMinute < 10) sMinute = "0" + sMinute; var sFloder = sYear + sMonth + sDay + sHour + sMinute; sFloder = "Z数据库备份//" + sFloder //WScript.echo(sFloder); //WScript.Quit(); //---------------------------- var oShell = WScript.CreateObject("WScript.Shell") //停止服务 oShell.Run("cmd /c net stop mssqlserver ", 1, true); //创建文件夹 oShell.Run("cmd /c md " + sFloder, 1, true); //拷贝文件 oShell.Run('cmd /c copy "D://Program Files//Microsoft SQL Server 2003//MSSQL//Data//ccenn_b2b_*.*" ' + sFloder, 1, true); oShell.Run('cmd /c copy "D://Program Files//Microsoft SQL Server 2003//MSSQL//Data//ccenn_news_*.*" ' + sFloder, 1, true); oShell.Run('cmd /c copy "D://Program Files//Microsoft SQL Server 2003//MSSQL//Data//ccenn_sys_*.*" ' + sFloder, 1, true); //启动服务 oShell.Run("cmd /c net start mssqlserver ", 1, true); //提示并退出 oShell = null; WScript.echo("完成,放在",sFloder); WScript.Quit();