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

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

MSDE on XP running, but not recognized in ODBC

I installed an MSDE instance for a user running XP with an
admin Windows account. The MSDE Server icon appears in
the notification area, but without the green arrow. Task
manager shows that it is running. Trying to start it up
manually doesn't do anything. When I go to add the Data
Source in ODBC, System DSN (MDAC 2.8 is installed), when
we go to pick the MSDE Server, it doesn't appear in the
drop down when picking a server. Any thoughts or ideas
would be great. Thanks, JRaub.
hi JRaub,
JRaub wrote:
> I installed an MSDE instance for a user running XP with an
> admin Windows account. The MSDE Server icon appears in
> the notification area, but without the green arrow. Task
> manager shows that it is running. Trying to start it up
> manually doesn't do anything. When I go to add the Data
> Source in ODBC, System DSN (MDAC 2.8 is installed), when
> we go to pick the MSDE Server, it doesn't appear in the
> drop down when picking a server. Any thoughts or ideas
> would be great. Thanks, JRaub.
please have a look at
http://support.microsoft.com/default...b;EN-US;814132
if you want to modify the networkprotocols setting, please run the Server
Network Utility (svrnetcn.exe) and enable the desired protocol
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks. I'll give this a shot. Nothing else has worked.[vbcol=seagreen]
>--Original Message--
>hi JRaub,
>JRaub wrote:
an[vbcol=seagreen]
Task
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;814132
>if you want to modify the networkprotocols setting,
please run the Server
>Network Utility (svrnetcn.exe) and enable the desired
protocol
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>
>.
>