|
|
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
Navigation:
[Reply to this message]
|