Backup and restore of SQL Server 2014 stored procedures

SQL Server 2014 stored procedure Backup and recovery ... 1

1. Backup stored procedure: ... 1

2, restore ... 8

SQL Server 2014 stored procedure Backup and Recovery 1, backup stored procedures:

Back up the stored procedure in the database management software first

How to: Database-"programmability-" stored procedures

See there are several stored procedures, and then

Select Production Script

Select Next

You can also expand the selection of stored procedures to be backed up:

Choose Next, set scripting options: OK;

Select Next after selecting OK

The backup stored procedure is started:

Backup complete:

Locate the backup location for the stored procedure on the disk:

2, restore

To manually delete a stored procedure:

After the deletion, the stored procedure that you just backed up is opened with Notepad, if you delete it by mistake, select it all, execute it as a SQL statement again, the stored procedure will be restored, if it is deleted individually, you can select the statement of the stored procedure separately, then execute again, and the stored procedure will recover.

The operation is as follows:

Effect:

Backup and restore of SQL Server 2014 stored procedures