常用 SQL Server 脚本

运行维护

备份还原

# server_name
# user_name
# password
# database_name
# backup_path，备份路径，X:PathToBackupLocation[Name_of_Database].bak
SQLCMD -S {server_name} -U {user_name} -P {password} -d master -Q"BACKUP DATABASE {database_name} to disk='{backup_path}'"