Backing Up Stored Procedures

jfalk

How would you go about backing up stored procedures and then restoring them either on the same server if need be or on another server?

Thanks

jfalk

Does not anyone have a clue?

Eddie D

Hi

I am not aware of any SQL Server Backup applications that will perform a backup of stored procedures invidually.

When you perform a Full backup of a database all the stored procedures in the database are backed up along with all the other database objects.

New to SQL Server 2005 is the concept of projects where you can save your stored procedure creation scripts, along with all the other database objects that you create.

Mircosoft describe a project as: "A database script project is an organized set of scripts, connection information, and templates that are all associated with a database or one part of a database. Microsoft SQL Server 2005 provides the SQL Server Management Studio for administering and designing SQL Server databases within the context of a script project. SQL Server Management Studio includes designers, editors, guides and wizards to assist users in developing, deploying and maintaining databases."(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c2e80045-894d-44cf-b65c-e547ed738947.htm)

Further information regarding projects can be found in SQL Server 2005 Books On-Line.

Another alternative is to copy the stored procedure T-SQL Script and paste into a notepad or word document and save the resulting document.

Best Regards
Eddie Davis
Red Gate Software
Technical Support

jfalk

Thank You!