What are the challenges you face when working across database platforms? Take the survey

Backing Up Stored Procedures

jfalkjfalk Posts: 6
edited January 11, 2007 1:31PM in SQL Backup Previous Versions
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?



  • Options
    Does not anyone have a clue?
  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5

    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    Thank You!
Sign In or Register to comment.