Sqlschools.com
Just be an expert in sqlserver.
Page
Home
Contact us
About Us
Showing posts with label
BackUp database
.
Show all posts
Showing posts with label
BackUp database
.
Show all posts
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
Older Posts
Home
Subscribe to:
Posts (Atom)