How Can I recover the SA password?

Hi
I´m the SQL administrator, and I want recover the SA password, I do not want
reset it, I want recover.
Thanks and have a nice dayI've never done it but here:
http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/200=
3-03/0790.html
On Oct 10, 3:24 pm, Oseas Millan
<OseasMil...@.discussions.microsoft.com> wrote:
> Hi
> I=B4m the SQL administrator, and I want recover the SA password, I do not= want
> reset it, I want recover.
> Thanks and have a nice day|||Thanks Pawn.
Let me try
"Pawn" wrote:
> I've never done it but here:
> http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-03/0790.html
> On Oct 10, 3:24 pm, Oseas Millan
> <OseasMil...@.discussions.microsoft.com> wrote:
> > Hi
> >
> > I´m the SQL administrator, and I want recover the SA password, I do not want
> > reset it, I want recover.
> >
> > Thanks and have a nice day
>
>

How can I recover suspect Database , SQL 2005

Hi all
I have e big problem , I have a database in SQL 2005 which is mark as
suspect. I think the main reason for this is that someone have stopped tha
database engine , while it has been working. Now the database is shown as
suspect. I try to execute several queries, but nothing helped. I think that
the database log file is broken , when I try to Attach the database on
another server I get message that there is a missing record in the database.
Can someone help to recover the database , or to get the information from it
?
Plamen,
you might want PSS to work through this with you, but the essential points
are listed here: http://www.myitforum.com/articles/18/view.asp?id=7381
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"Plamen Assenov" <Plamen Assenov@.discussions.microsoft.com> wrote in message
news:88E41664-0265-4066-8FE9-450546FBCAAB@.microsoft.com...
> Hi all
> I have e big problem , I have a database in SQL 2005 which is mark as
> suspect. I think the main reason for this is that someone have stopped tha
> database engine , while it has been working. Now the database is shown as
> suspect. I try to execute several queries, but nothing helped. I think
> that
> the database log file is broken , when I try to Attach the database on
> another server I get message that there is a missing record in the
> database.
> Can someone help to recover the database , or to get the information from
> it
> ?

How can I recover suspect Database , SQL 2005

Hi all
I have e big problem , I have a database in SQL 2005 which is mark as
suspect. I think the main reason for this is that someone have stopped tha
database engine , while it has been working. Now the database is shown as
suspect. I try to execute several queries, but nothing helped. I think that
the database log file is broken , when I try to Attach the database on
another server I get message that there is a missing record in the database.
Can someone help to recover the database , or to get the information from it
?Plamen,
you might want PSS to work through this with you, but the essential points
are listed here: http://www.myitforum.com/articles/18/view.asp?id=7381
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Hi
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
"Plamen Assenov" <Plamen Assenov@.discussions.microsoft.com> wrote in message
news:88E41664-0265-4066-8FE9-450546FBCAAB@.microsoft.com...
> Hi all
> I have e big problem , I have a database in SQL 2005 which is mark as
> suspect. I think the main reason for this is that someone have stopped tha
> database engine , while it has been working. Now the database is shown as
> suspect. I try to execute several queries, but nothing helped. I think
> that
> the database log file is broken , when I try to Attach the database on
> another server I get message that there is a missing record in the
> database.
> Can someone help to recover the database , or to get the information from
> it
> ?

How Can I recover master database from master's backup?

I did a new instalation, and I want to recover master
database from master's backup, but the system show me the
next message RESTORE DATABASE must be in single user mode
when trying to restore the master database.
It's very important to me get information about the
aplication's users but I can't do that.
The system don't permit to put in single user mode to
master then I don't no what to do for resolving this.
Somebody Help me ?
Thanks LorenaSee my other post. No need to re-post.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lorena" <anonymous@.discussions.microsoft.com> wrote in message
news:bba401c40dea$4e4130a0$a001280a@.phx.gbl...
> I did a new instalation, and I want to recover master
> database from master's backup, but the system show me the
> next message RESTORE DATABASE must be in single user mode
> when trying to restore the master database.
> It's very important to me get information about the
> aplication's users but I can't do that.
> The system don't permit to put in single user mode to
> master then I don't no what to do for resolving this.
> Somebody Help me ?
> Thanks Lorena
>sql