SQL Server 2000 Backup of Stored Procedures

[Hoardling via AccessMonster.com]

When I do a complete backup of the database does it save the stored
procedures? If not how can the stored procedures be saved in case of a
catastrophic server failure?

 

[Sylvain Lafontaine]

Yes, stored procedures are saved as you can easily see by restoring a backup
to a new database. However, there are other things like the Login accounts
that are saved in the master database; these are not saved if you are
backuping only your database. That may or may not be a concern for you.

You should ask this kind of question to a newsgroup dedicated to sql-server
such as m.p.sqlserver.server or m.p.sqlserver.security .

 

[Mary Chipman [MSFT]]

You can save the definitions of all of your objects as script files,
which are stored in plain text. Scripting objects is a feature that is
available in SEM for SQLS 2000 and SSMS in SQLS 2005. Because they are
in plain text they don't take up much room on disk. To see what this
looks like, download the scripts that create the Northwind and pubs
sample databases, which also contain the insert statements for the
data (but you don't need that part).

-Mary