SQL Server methods for backing up database stored procedures _mssql

SQL Server bulk Export stored procedures

In Query Analyzer, select the database--right--"task"--"Generate script" from the pop-up menu

--"Next"--"Select the database where you want to store the procedure--"

"Next"--check "stored Procedures" and next--"

Tick the name of the stored procedure you want to generate and next--"

Choose to save the script to a file and choose Save path--"complete

There is also a direct implementation through the SQL statement:

Set ANSI_NULLS on
SET QUOTED_IDENTIFIER on
go
 
 
ALTER PROCEDURE [dbo].[ Dbbak]  
 
as 
BEGIN 
  DECLARE @sqlCommand NVARCHAR (1000) 
  DECLARE @dateTime NVARCHAR (a) 
  SELECT @ DateTime = REPLACE (CONVERT (VARCHAR, GETDATE (), (), '/', ') + 
  REPLACE (CONVERT (VARCHAR, GETDATE (), 108), ': ', ')  
  SET @sqlCommand = ' BACKUP DATABASE blnbusydata to DISK = ' D:\DataBaseBakUp\bln_ ' + @dateTime + '. BAK ' ' 
  EXECUTE sp_executesql @sqlCommand End