Friday, March 30, 2012

MSDE SQL Database Marked 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
Jason,
You might check with Veritas regarding the Backup Exec.. The 4IDR part of
the filenames may have to do with their Intelligent Disaster Recovery..
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Jason Hunsberger" <systems182@.nospam_andersontech.com> wrote in message
news:umOi6EWDFHA.208@.TK2MSFTNGP12.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

No comments:

Post a Comment