how to if needed recover from mistake

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

Re: how to if needed recover from mistake

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

Re: how to if needed recover from mistake

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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: how to if needed recover from mistake

On Wed, 16 May 2007 22:46:15 +0000 (UTC), Erland Sommarskog
wrote:

>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!
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