python 脚本bak文件还原mssql数据库

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

# -*- coding=utf-8 -*- import pyodbc from datetime import datetime import pymssql import decimal class SQLServer:     def __init__(self,server,user,password,database,autocommit):         self.server = server         self.user = user         self.password = password         self.database = database         self.autocommit = autocommit       def __GetConnect(self):         if not self.database:             raise(NameError,"没有数据库信息")         self.conn = pymssql.connect(server=self.server,user=self.user,password=self.password,database=self.database,autocommit=self.autocommit)         cur = self.conn.cursor()         if not cur:             raise(NameError,"连接数据库失败")         else:             return cur           def restoreDb(self,database,restorepath):         cur = self.__GetConnect()         restorePath = restorepath + database + datetime.now().strftime("%Y%m%d") + '.bak'         sql = "RESTORE DATABASE [{0}] FROM DISK = N'{1}' WITH FILE=1,Replace,stats = 10".format(database,restorePath)         cur.execute(sql)         self.conn.close() def main():     msg = SQLServer(server="192.168.2.190",user="sa",password="P123",database="master",autocommit=True)     msg.restoreDb("wanghz","D:\\backup\\")   if __name__ == "__main__":     main()