一、备份命令脚本
###backup.bat####
REM create backup files
C:
cd "\Program Files\Microsoft SQL Server\90\Tools\Binn"
sqlcmd -S localhost -U sa -P gzgi_2005 -i E:\backup\backup.sql -o e:\backup.log
######backup.bat#####
二、备份的SQL
#####backup.sql######
BACKUP DATABASE tank TO DISK = 'E:\backup\backuptemp\tank.bak' WITH INIT
GO
BACKUP LOG tank TO DISK = 'E:\backup\backuptemp\tank_log.bak' WITH INIT
GO
########backup.sql#######
阅读(1819) | 评论(0) | 转发(0) |