备份数据库的存储过程.sql

CREATE PROCEDURE [dbo].[back_pubs] AS
declare
@filename nvarchar(100)
set @filename='F:/data/pub_bp'+convert(char(10),getdate(),112) --目录一定要存在
print @filename
BACKUP DATABASE [pubs]
TO DISK = @filename WITH NOINIT ,
NOUNLOAD ,
NAME = N'pubs备份',
NOSKIP ,
STATS = 10,
NOFORMAT

exec back_pubs