the mssqlserver service on local computer started and then stopped

Question

Post reply

the mssqlserver service on local computer started and then stopped

siva.l.prasad

SSC Enthusiast

Points: 162
More actions
November 6, 2008 at 5:20 am

#72090

hi,
in sqlserver 2000 machine ,after new instalation i am facing a problem like
the mssqlserver service on local computer started and then stopped...
here is the error log
2008-11-06 06:53:01.03 server Microsoft SQL Server 2000 - 8.00.2187 (Intel X86)
Mar 9 2006 11:38:51
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2008-11-06 06:53:01.03 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-11-06 06:53:01.03 server All rights reserved.
2008-11-06 06:53:01.03 server Server Process ID is 1984.
2008-11-06 06:53:01.03 server Logging SQL Server messages in file 'd:\MSSQL\log\ERRORLOG'.
2008-11-06 06:53:01.03 server SQL Server is starting at priority class 'normal'(8 CPUs detected).
2008-11-06 06:53:01.07 server SQL Server configured for thread mode processing.
2008-11-06 06:53:01.07 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-11-06 06:53:01.21 server Attempting to initialize Distributed Transaction Coordinator.
2008-11-06 06:53:03.24 spid3 Starting up database 'master'.
2008-11-06 06:53:03.24 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-11-06 06:53:03.24 spid5 Starting up database 'model'.
2008-11-06 06:53:03.24 spid3 Server name is 'SPRPXAPT06'.
2008-11-06 06:53:03.24 spid5 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf.
2008-11-06 06:53:03.24 spid5 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf for virtual device number (VDN) 1.
2008-11-06 06:53:03.26 spid8 Starting up database 'msdb'.
2008-11-06 06:53:03.24 spid10 Starting up database 'Execuvue_Test'.
2008-11-06 06:53:03.26 spid9 Starting up database 'StageDataBus'.
2008-11-06 06:53:03.26 spid5 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf' may be incorrect.
2008-11-06 06:53:03.26 spid12 Starting up database 'cm82'.
2008-11-06 06:53:03.26 spid11 Starting up database 'db_admin'.
2008-11-06 06:53:03.26 spid10 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\Execuvue_Test_Data.MDF.
2008-11-06 06:53:03.26 spid9 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\StageDataBus_Data.MDF.
2008-11-06 06:53:03.26 spid8 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf.
2008-11-06 06:53:03.26 spid10 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\Execuvue_Test_Data.MDF for virtual device number (VDN) 1.
2008-11-06 06:53:03.26 spid9 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\StageDataBus_Data.MDF for virtual device number (VDN) 1.
2008-11-06 06:53:03.26 spid8 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf for virtual device number (VDN) 1.
2008-11-06 06:53:03.26 spid12 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\cm82_Data.MDF.
2008-11-06 06:53:03.26 spid10 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\Execuvue_Test_Data.MDF' may be incorrect.
2008-11-06 06:53:03.26 spid9 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\StageDataBus_Data.MDF' may be incorrect.
2008-11-06 06:53:03.26 spid5 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\modellog.ldf' may be incorrect.
2008-11-06 06:53:03.26 spid11 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\db_admin_Data.MDF.
2008-11-06 06:53:03.26 spid12 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\cm82_Data.MDF for virtual device number (VDN) 1.
2008-11-06 06:53:03.26 spid8 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf' may be incorrect.
2008-11-06 06:53:03.26 spid10 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\Execuvue_Test_Log.LDF' may be incorrect.
2008-11-06 06:53:03.26 spid11 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\db_admin_Data.MDF for virtual device number (VDN) 1.
2008-11-06 06:53:03.26 spid9 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\StageDataBus_Log.LDF' may be incorrect.
2008-11-06 06:53:03.26 spid8 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\msdblog.ldf' may be incorrect.
2008-11-06 06:53:03.26 spid10 Starting up database 'FIN_DATAMART'.
2008-11-06 06:53:03.26 spid5 Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2008-11-06 06:53:03.26 spid12 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\cm82_Data.MDF' may be incorrect.
2008-11-06 06:53:03.26 spid11 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\db_admin_Data.MDF' may be incorrect.
2008-11-06 06:53:03.26 spid12 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\cm82_Log.LDF' may be incorrect.
2008-11-06 06:53:03.26 spid11 Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\db_admin_Log.LDF' may be incorrect.
2008-11-06 06:53:03.26 spid10 udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\FIN_DATAMART_Data.MDF.
any suggessions

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 1

Check if the folder exists and check if the files inside the path also exists

C:\Program Files\Microsoft SQL Server\MSSQL\data\

"-=Still Learning=-"

Lester Policarpio