Apr 6, 2012

BackUp database in sqlserver 2008

create procedure [dbo].[backupdb]
as

BACKUP DATABASE [Demo] TO DISK = N'C:\backup\mybackup.sql'
WITH NOFORMAT
, NOINIT
, NAME = N'test copy'
, SKIP
, NOREWIND
, NOUNLOAD
, STATS = 10

exec backupdb

1 comment: