Navigation Bar

Tuesday, May 26, 2009

Back Database through Procedure in SQL 2005

CREATE Procedure spl_DBBackup
@DataBase as varchar(200),
@PathFileName as varchar(200),
AS
Begin
BACKUP DATABASE @DataBase TO DISK = @PathFileName WITH NOFORMAT, NOINIT, NAME = N'DMS Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
End

No comments:

Post a Comment