sql 2005 erpress 备份

sqlcmd -S sv2\sqlexpress -E -i E:\BackupFiles\SQLDB_BackUp.sql >> LOG\SQLDB_BACKUP_LOG.txt

 

--type E:\BackupFiles\SQLDB_BackUp.sql---
USE [master]
GO
BACKUP DATABASE [SQLDB] TO  DISK = N'E:\BackupFiles\SQL_DATA\SQLDB.BAK' WITH NOFORMAT, NOINIT,  NAME = N'SQLDB.BAK', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO