Sqlschools.com
Just be an expert in sqlserver.
Page
Home
Contact us
About Us
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:
Arvind Kumar
April 30, 2013 at 1:47 PM
thanks to write this..helpful info for learners
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
thanks to write this..helpful info for learners
ReplyDelete