My databse listed above is set to SUSPECT and I cant
recover it.

I have not tried to reinstall or repair Biztalk. I thought
someone may want the raw issue.

What happened.  My system shutdown randomlly and when it
came back that was the result.

Biztalk 2004 will not start, nor can I recover through
sp_resetstatus.

Any suggestions would be thankful..

Thanks
Dan

[ Post a follow-up to this message ]

Hi Dan, I'd recommend restoring a backup of this database as the first
course of action.  If there is no backup then you will most likely need to
run through the configframework wizard again to configure/recreate the
databases.
You may be able to post in the SQL support groups for suggestions on
recovering databases marked as suspect, but most likely we've lost
configuration/deployed assembly information from this.

Larry Franks

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| Content-Class: urn:content-classes:message
| From: "Dan" <daniel_meland@msn.com>
| Sender: "Dan" <daniel_meland@msn.com>
| Subject: BizTalkMgmtDb is set to SUSPECT cant recover
| Date: Sat, 27 Mar 2004 17:42:57 -0800
| Lines: 17
| Message-ID: <11c6201c41465$ff2f0320$a601280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| 	charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQUZf8v8gEls1iIRSugmyt8hvOvEw==
| Newsgroups: microsoft.public.biztalk.general
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:13521
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.biztalk.general
|
|
| My databse listed above is set to SUSPECT and I cant
| recover it.
|
| I have not tried to reinstall or repair Biztalk. I thought
| someone may want the raw issue.
|
| What happened.  My system shutdown randomlly and when it
| came back that was the result.
|
| Biztalk 2004 will not start, nor can I recover through
| sp_resetstatus.
|
| Any suggestions would be thankful..
|
| Thanks
| Dan
|

[ Post a follow-up to this message ]

That is what I expected.
I did not know if MS was aware of the problem.


Thank you
Dan

>-----Original Message-----
>Hi Dan, I'd recommend restoring a backup of this database
as the first
>course of action.  If there is no backup then you will
most likely need to
>run through the configframework wizard again to
configure/recreate the
>databases.
>You may be able to post in the SQL support groups for
suggestions on
>recovering databases marked as suspect, but most likely
we've lost
>configuration/deployed assembly information from this.
>
>Larry Franks
>
>This posting is provided "AS IS" with no warranties,and
confers no rights.
>Subscribe at
>http://support.microsoft.com/default.aspx?
scid=/servicedesks/msdn/nospam.asp
>&SD=msdn
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Dan" <daniel_meland@msn.com>
>| Sender: "Dan" <daniel_meland@msn.com>
>| Subject: BizTalkMgmtDb is set to SUSPECT cant recover
>| Date: Sat, 27 Mar 2004 17:42:57 -0800
>| Lines: 17
>| Message-ID: <11c6201c41465$ff2f0320$a601280a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| 	charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Thread-Index: AcQUZf8v8gEls1iIRSugmyt8hvOvEw==
>| Newsgroups: microsoft.public.biztalk.general
>| Path: cpmsftngxa06.phx.gbl
>| Xref: cpmsftngxa06.phx.gbl
microsoft.public.biztalk.general:13521
>| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
>| X-Tomcat-NG: microsoft.public.biztalk.general
>|
>|
>| My databse listed above is set to SUSPECT and I cant
>| recover it.
>|
>| I have not tried to reinstall or repair Biztalk. I
thought
>| someone may want the raw issue.
>|
>| What happened.  My system shutdown randomlly and when
it
>| came back that was the result.
>|
>| Biztalk 2004 will not start, nor can I recover through
>| sp_resetstatus.
>|
>| Any suggestions would be thankful..
>|
>| Thanks
>| Dan
>|
>
>.
>

[ Post a follow-up to this message ]

Thanks Larry,
and BTW it is a torn page, and my disk is good, so...

Thanks again
Dan

>-----Original Message-----
>Hi Dan, I'd recommend restoring a backup of this database
as the first
>course of action.  If there is no backup then you will
most likely need to
>run through the configframework wizard again to
configure/recreate the
>databases.
>You may be able to post in the SQL support groups for
suggestions on
>recovering databases marked as suspect, but most likely
we've lost
>configuration/deployed assembly information from this.
>
>Larry Franks
>
>This posting is provided "AS IS" with no warranties,and
confers no rights.
>Subscribe at
>http://support.microsoft.com/default.aspx?
scid=/servicedesks/msdn/nospam.asp
>&SD=msdn
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Dan" <daniel_meland@msn.com>
>| Sender: "Dan" <daniel_meland@msn.com>
>| Subject: BizTalkMgmtDb is set to SUSPECT cant recover
>| Date: Sat, 27 Mar 2004 17:42:57 -0800
>| Lines: 17
>| Message-ID: <11c6201c41465$ff2f0320$a601280a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| 	charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Thread-Index: AcQUZf8v8gEls1iIRSugmyt8hvOvEw==
>| Newsgroups: microsoft.public.biztalk.general
>| Path: cpmsftngxa06.phx.gbl
>| Xref: cpmsftngxa06.phx.gbl
microsoft.public.biztalk.general:13521
>| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
>| X-Tomcat-NG: microsoft.public.biztalk.general
>|
>|
>| My databse listed above is set to SUSPECT and I cant
>| recover it.
>|
>| I have not tried to reinstall or repair Biztalk. I
thought
>| someone may want the raw issue.
>|
>| What happened.  My system shutdown randomlly and when
it
>| came back that was the result.
>|
>| Biztalk 2004 will not start, nor can I recover through
>| sp_resetstatus.
>|
>| Any suggestions would be thankful..
>|
>| Thanks
>| Dan
>|
>
>.
>

[ Post a follow-up to this message ]