Friday, March 30, 2012

MSDE SQL Server marked as SUSPECT

Hello all! I have an instance of MSDE that is marked as SUSPECT. In
the error log I get:
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'.
Operating system error 3(The system cannot find the path specified.).
The statement is proceeding but is non-restartable.
We don't have Enteprise Manager to look any closer at the DB. Do any of
you have a suggestion as to how to get this DB operational?
Jason
Restore it from a known good backup.
Jim
"Jason Hunsberger" <systems182@.nospam_andersontech.com> wrote in message
news:u1ZDFhWDFHA.3020@.TK2MSFTNGP09.phx.gbl...
> Hello all! I have an instance of MSDE that is marked as SUSPECT. In the
> error log I get:
> I/O error on backup or restore restart-checkpoint file 'C:\Program
> Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'.
> Operating system error 3(The system cannot find the path specified.). The
> statement is proceeding but is non-restartable.
> We don't have Enteprise Manager to look any closer at the DB. Do any of
> you have a suggestion as to how to get this DB operational?
> Jason
sql

No comments:

Post a Comment