Posted by Erland Sommarskog on 05/16/07 22:46

Jeff Kish (jeff.kish@mro.com) writes:
> I deleted a stored procedure (one I had written) out of the master
> database. I thought I had accidentally put it there, then I got to
> thinking.. what if it is normally reflected there, and maybe I should
> not of deleted it.

If you found your procedure in master, it was because you added it there,
probably by mistake.


> So.. my question.. is it normal for procedures in other databases to be
> reflected also in the master database,

Well, you are not the first to make the mistake. But that's not the same
thing as normal.

> and then how can I restore / recover the master database if necessary.

I recommend that you read in Books Online if you are interested in
this exercise. That's at least where I would look, if I would run into
the situation that I would need to restore a master database. I don't
do it often enough to know the procedures by heart!



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]