DB Suspect...

I'm using SQL Server 2K n 1 fine morning I recieve this
error saying "Database Suspect", in Enterprise Manager.
By the way, I'm using Windows NT.
How can I get my DB out of this Suspect mode?
Any answers will be highly appreciated.That CANNOT be a reason by any chance. As said have you tried the options
specified in the SQL Server BOL ?
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
"Biju" <reachcybercop@.yahoo.com> wrote in message
news:0e6201c37e83$75a614e0$a101280a@.phx.gbl...
> Well, I had installed SP3 just a couple of days back.
> Could this be the reason?
> >--Original Message--
> >Check in the SQL Server error logs and the NT event logs
> first. You
> >need to also know why it went west to prevent it
> happening again.
> >
> >Check out this in BOL also
> >
> >mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
> 20Server\80\Tools\Book
> >s\trblsql.chm::/tr_servdatabse_494j.htm
> >
> >
> >Also just in case I would start to dig out your Backups.
> >
> >
> >Allan Mitchell (Microsoft SQL Server MVP)
> >MCSE,MCDBA
> >www.SQLDTS.com
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >.
> >|||I wouldn't have thought so (SP3 what ? DB, Windows) as you would have
had to have rebooted after applying it and I would have expected things
to go west then. What do the logs say? Do you have enough Disk space?
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org|||following err message comes up in SQL Server log:
Device activation error. The physical file
name 'C:\Program Files\Seagate
Software\Enterprise\ODBCSUPT\CE8_log.ldf' may be incorrect.
>--Original Message--
>Well, I had installed SP3 just a couple of days back.
>Could this be the reason?
>>--Original Message--
>>Check in the SQL Server error logs and the NT event logs
>first. You
>>need to also know why it went west to prevent it
>happening again.
>>Check out this in BOL also
>>mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
>20Server\80\Tools\Book
>>s\trblsql.chm::/tr_servdatabse_494j.htm
>>
>>Also just in case I would start to dig out your Backups.
>>
>>Allan Mitchell (Microsoft SQL Server MVP)
>>MCSE,MCDBA
>>www.SQLDTS.com
>>I support PASS - the definitive, global community
>>for SQL Server professionals - http://www.sqlpass.org
>>.
>.
>|||have enough disk space
>--Original Message--
>following err message comes up in SQL Server log:
>Device activation error. The physical file
>name 'C:\Program Files\Seagate
>Software\Enterprise\ODBCSUPT\CE8_log.ldf' may be
incorrect.
>
>>--Original Message--
>>Well, I had installed SP3 just a couple of days back.
>>Could this be the reason?
>>--Original Message--
>>Check in the SQL Server error logs and the NT event
logs
>>first. You
>>need to also know why it went west to prevent it
>>happening again.
>>Check out this in BOL also
>>mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
>>20Server\80\Tools\Book
>>s\trblsql.chm::/tr_servdatabse_494j.htm
>>
>>Also just in case I would start to dig out your Backups.
>>
>>Allan Mitchell (Microsoft SQL Server MVP)
>>MCSE,MCDBA
>>www.SQLDTS.com
>>I support PASS - the definitive, global community
>>for SQL Server professionals - http://www.sqlpass.org
>>.
>>.
>.
>|||In article <7f1701c37e88$ab23d490$a601280a@.phx.gbl>, Biju wrote:
> activation error. The physical file
> name 'C:\Program Files\Seagate
> Software\Enterprise\ODBCSUPT\CE8_log.ldf
>
check for
A. Diskspace on C:\
B. The existence of the file
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org