备份:
在cmd窗口输入:
sqlcmd -S localhost\MSSQLSERVER,1433 -U sa -P 123456 -d master -Q"BACKUP DATABASE test to disk='c:/backup/test.bak'"
还原:
sqlcmd -S localhost\MSSQLSERVER,1433 -U sa -P 123456 -d master -Q"RESTORE DATABASE test FROM disk='c:/backup/test.bak'"