Tuesday, July 15, 2008
How to back up a database using script in SQL SERVER 2005
Use this script in order to backup a database :/*Author : Suprotim AgarwalCreation Date: Jan 2, 2008*/CREATE PROCEDURE [dbo].[usersp_BackUpDB]@DBNAME nvarchar(50),@PATH nvarchar(200),@BCKUPNAME nvarchar(50)ASBACKUP DATABASE @DBNAMETO DISK = @PATHWITH NOFORMAT, NOINIT,NAME = @BCKUPNAME,STATS = 10You can call this script using :DECLARE @return_value intEXEC @return_value = [dbo].[usersp_BackUpDB]@DBNAME = N'Northwind',@PATH = N'C:\temp\Northwind.bak',@BCKUPNAME = N'NW'SELECT 'Return Value' = @return_valueGO
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment