备份管理

SELECT 
    DB_NAME(database_id) AS DatabaseName,
    CAST(SUM(size) * 8 / 1024.0 AS DECIMAL(10,2)) AS 大小MB
FROM 
    sys.master_files
GROUP BY 
    database_id
ORDER BY 
    大小MB DESC;

备份全部数据库

sqlcmd -E -S . -Q "EXEC sp_MSforeachdb 'IF ''?'' NOT IN (''master'',''tempdb'',''model'',''msdb'') BEGIN BACKUP DATABASE [?] TO DISK = ''D:/temp/?.bak'' WITH INIT, FORMAT END'"

备份指定数据库

sqlcmd -E -S .\SQLEXPRESS -Q "BACKUP DATABASE ABC 
  TO DISK = 'D:\Backups\ABC.bak' 
  WITH NOFORMAT, NOINIT, NAME='ABC-Complete Database Backup', SKIP, 
  NOREWIND, NOUNLOAD, STATS=10 

USE ABC
GO
BACKUP DATABASE ABC 
  FILEGROUP = 'PRIMARY' 
  TO DISK = 'D:\Backups\ABC.bak' 
  WITH NOFORMAT, NOINIT, NAME='ABC-Partial Database Backup', SKIP, 
  NOREWIND, NOUNLOAD, STATS=10,
  EXCLUDE = { 'dbo.Table1', 'dbo.Table2' }
GO