Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. # 生成备份文件 && 打包为zip && 删除备份文件
  2. sqlcmd -S . -U sa -P 123 -Q "BACKUP DATABASE netnr TO DISK = '/netnr/data/netnr.bak' with format" && cd /netnr/data && zip -r netnr.zip netnr.bak && rm -rf netnr.bak
  3.  
  4. # 备份
  5. sqlcmd -S . -U sa -P 密码 -Q "BACKUP DATABASE 数据库 TO DISK = '备份路径' with format"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement