求backup语句

Question

CREATE PROCEDURE bk ASBACKUP DATABASE u67
   TO DISK = 'd:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\u67.bak'GO每次执行后bak文件都会增大。如何备份整个数据库，重写备份，并备份后验证完整性？

Answer 1

--备份；with init覆盖|noinit添加
backup database 库名 to disk='E:\H_BACKUP.bak' with init

Answer 2

即：CREATE PROCEDURE bk 
AS
    BACKUP DATABASE u67
    TO DISK = 'd:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\u67.bak' with init
GO

Answer 3

BACKUP DATABASE backname
    TO DISK = 'd:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\u67.bak' with init