Re: how to if needed recover from mistake
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 16 May 2007 22:46:15 +0000 (UTC)
Jeff Kish (jeff.kish@xxxxxxx) 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@xxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: how to if needed recover from mistake
- From: Jeff Kish
- Re: how to if needed recover from mistake
- References:
- how to if needed recover from mistake
- From: Jeff Kish
- how to if needed recover from mistake
- Prev by Date: Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities
- Next by Date: Re: Search for a table/string within job steps, dts, database, stored procedures etc
- Previous by thread: Re: how to if needed recover from mistake
- Next by thread: Re: how to if needed recover from mistake
- Index(es):
Relevant Pages
|
