how to if needed recover from mistake

[Jeff Kish]

Hi.
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.

So.. my question.. is it normal for procedures in other databases to be
reflected also in the master database, and then how can I restore / recover
the master database if necessary.

I am using sql server 2005 on XP pro.

thanks for the advice
Jeff Kish

[Ed Murphy]

Jeff Kish wrote:

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.

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

Not in my experience. I haven't used SQL Server 2005 yet, but this
doesn't seem like something that would have changed there. I would
guess that someone just forgot to pick the right the database before
running a CREATE PROCEDURE command.

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

I am using sql server 2005 on XP pro.

Googling ("SQL Server 2005" "restore master") turns up
http://msdn2.microsoft.com/en-us/library/ms190190.aspx

[Erland Sommarskog]

Jeff Kish (je*******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Jeff Kish]

On Wed, 16 May 2007 22:46:15 +0000 (UTC), Erland Sommarskog
<es****@sommarskog.sewrote:

>Jeff Kish (je*******@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!

Thanks much.
I keep getting my priorities switched around... its hard to keep up on all the
docs, but I keep peeking in there.
Jeff Kish