備份sqlserver 資料庫到遠程主機指令碼

標籤：備份   sqlserver   sqlserver備份   

備份sqlserver 資料庫到遠程主機指令碼

mssqlBackup.py：

# Name: mssqlBackup.py# Purpose: ## Author: yanglixue## Created: 2015/04/01#-------------------------------------------------------------------------------import pymssqlimport datetimeimport loggingimport tracebackimport os log_format = ‘%(filename)s [%(asctime)s] [%(levelname)s] %(message)s‘log_file="c:\\" + "backup_" +datetime.datetime.now().strftime("%Y-%m-%d") + ".log"logging.basicConfig(filename=log_file,format=log_format,level=logging.INFO)backupdir="E:\\backup\\"delcmd="D:\EclipseWork\mssqlBackup\del.bat >> c:\\" + "del_" +datetime.datetime.now().strftime("%Y-%m-%d") + ".log"dbs=[‘db2‘,‘test‘]try:        logging.info("connect database ......")        conn=pymssql.connect(host=‘10.1.1.2‘,database=‘master‘,user=‘sa‘,password=‘[email protected]‘,autocommit=True)    cur=conn.cursor()         for dbname in dbs:                now = datetime.datetime.now()           sdate = now.strftime("%Y-%m-%d_%H-%M-%S")                bakname=backupdir + dbname + "_" + sdate + ".bak"        sql = "".join(["backup database [",                       dbname,                       "] to disk=N‘"+ bakname,                       "‘ with noinit,noformat,checksum,stop_on_error"                      ]                      )        cur.execute(sql)                logging.info(sql)        logging.info("db:" + dbname + "  OK. ")          conn.close()    logging.info(delcmd)    out = os.system(delcmd)      logging.info(delcmd + " " + str(out))            except Exception as ex:    logging.error("Exception:" + traceback.format_exc())

del.bat：

echo "start ..." @echo onxcopy E:\backup\* \\192.168.1.11\E$\dbbackupdel E:\backup\* /Q

本文出自 “與IT一起的日子” 部落格，請務必保留此出處http://raugher.blog.51cto.com/3472678/1628075

備份sqlserver 資料庫到遠程主機指令碼