ERRORLOG 2002-04-29 16:29:06.00 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Desktop Edition on Windows 4.10 (Build 2222: A )2002-04-29 16:29:06.09 kernel Copyright (C) 1988-1997 Microsoft Corporation. 2002-04-29 16:29:06.09 kernel All rights reserved. 2002-04-29 16:29:06.09 kernel Logging SQL Server messages in file 'f:\MSSQL7\log\ERRORLOG'. 2002-04-29 16:29:06.13 kernel initconfig: Number of user connections limited to 32767. 2002-04-29 16:29:06.13 kernel SQL Server is starting at priority class 'normal'(1 CPU detected). 2002-04-29 16:29:06.17 kernel User Mode Scheduler configured for thread processing 2002-04-29 16:29:07.42 server Directory Size: 5345 2002-04-29 16:29:07.44 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks 2002-04-29 16:29:07.45 spid1 failed to get sqlservr image range 2002-04-29 16:29:07.45 spid1 Starting up database 'master'. 2002-04-29 16:29:07.45 spid1 Opening file f:\MSSQL7\data\master.mdf. 2002-04-29 16:29:07.49 spid1 Opening file f:\MSSQL7\data\mastlog.ldf. 2002-04-29 16:29:07.60 spid1 Loading SQL Server's Unicode collation. 2002-04-29 16:29:07.66 spid1 Loading SQL Server's non-Unicode sort order and character set. 2002-04-29 16:29:07.73 spid1 Starting up database 'model'. 2002-04-29 16:29:07.73 spid1 Opening file c:\mssql7\data\model.mdf. 2002-04-29 16:29:07.79 kernel udopen: Operating system error 3(系统找不到指定的路径。) during the creation/opening of physical device c:\mssql7\data\model.mdf. 2002-04-29 16:29:07.80 kernel FCB::Open failed: Could not open device c:\mssql7\data\model.mdf for virtual device number (VDN) 1. 2002-04-29 16:29:07.82 spid1 Device activation error. The physical file name 'c:\mssql7\data\model.mdf' may be incorrect. 2002-04-29 16:29:07.89 spid1 Database 'model' cannot be opened because some of the files could not be activated.
ERRORLOG.1 2002-04-29 16:21:43.03 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Desktop Edition on Windows 4.10 (Build 2222: A )2002-04-29 16:21:43.05 kernel Copyright (C) 1988-1997 Microsoft Corporation. 2002-04-29 16:21:43.05 kernel All rights reserved. 2002-04-29 16:21:43.05 kernel Logging SQL Server messages in file 'f:\MSSQL7\log\ERRORLOG'. 2002-04-29 16:21:43.05 kernel initconfig: Number of user connections limited to 32767. 2002-04-29 16:21:43.06 kernel SQL Server is starting at priority class 'normal'(1 CPU detected). 2002-04-29 16:21:43.06 kernel User Mode Scheduler configured for thread processing 2002-04-29 16:21:44.09 server Directory Size: 5345 2002-04-29 16:21:44.10 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks 2002-04-29 16:21:44.10 spid1 failed to get sqlservr image range 2002-04-29 16:21:44.10 spid1 Starting up database 'master'. 2002-04-29 16:21:44.10 spid1 Opening file f:\MSSQL7\data\master.mdf. 2002-04-29 16:21:44.13 spid1 Opening file f:\MSSQL7\data\mastlog.ldf. 2002-04-29 16:21:44.20 spid1 Loading SQL Server's Unicode collation. 2002-04-29 16:21:44.22 spid1 Loading SQL Server's non-Unicode sort order and character set. 2002-04-29 16:21:44.25 spid1 Starting up database 'model'. 2002-04-29 16:21:44.26 spid1 Opening file c:\mssql7\data\model.mdf. 2002-04-29 16:21:44.26 kernel udopen: Operating system error 3(系统找不到指定的路径。) during the creation/opening of physical device c:\mssql7\data\model.mdf. 2002-04-29 16:21:44.26 kernel FCB::Open failed: Could not open device c:\mssql7\data\model.mdf for virtual device number (VDN) 1. 2002-04-29 16:21:44.27 spid1 Device activation error. The physical file name 'c:\mssql7\data\model.mdf' may be incorrect. 2002-04-29 16:21:44.28 spid1 Database 'model' cannot be opened because some of the files could not be activated.
呵呵,有趣,路径改了就OK了,神奇2002-04-29 16:21:44.26 kernel udopen: Operating system error 3(系统找不到指定的路径。) during the creation/opening of physical device c:\mssql7\data\model.mdf. 2002-04-29 16:21:44.26 kernel FCB::Open failed: Could not open device c:\mssql7\data\model.mdf for virtual device number (VDN) 1. 2002-04-29 16:21:44.27 spid1 Device activation error. The physical file name 'c:\mssql7\data\model.mdf' may be incorrect. 2002-04-29 16:21:44.28 spid1 Database 'model' cannot be opened because some of the files could not be activated
建议重装一遍MSSQL
2002-04-29 16:29:06.00 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 2222: A )2002-04-29 16:29:06.09 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2002-04-29 16:29:06.09 kernel All rights reserved.
2002-04-29 16:29:06.09 kernel Logging SQL Server messages in file 'f:\MSSQL7\log\ERRORLOG'.
2002-04-29 16:29:06.13 kernel initconfig: Number of user connections limited to 32767.
2002-04-29 16:29:06.13 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2002-04-29 16:29:06.17 kernel User Mode Scheduler configured for thread processing
2002-04-29 16:29:07.42 server Directory Size: 5345
2002-04-29 16:29:07.44 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2002-04-29 16:29:07.45 spid1 failed to get sqlservr image range
2002-04-29 16:29:07.45 spid1 Starting up database 'master'.
2002-04-29 16:29:07.45 spid1 Opening file f:\MSSQL7\data\master.mdf.
2002-04-29 16:29:07.49 spid1 Opening file f:\MSSQL7\data\mastlog.ldf.
2002-04-29 16:29:07.60 spid1 Loading SQL Server's Unicode collation.
2002-04-29 16:29:07.66 spid1 Loading SQL Server's non-Unicode sort order and character set.
2002-04-29 16:29:07.73 spid1 Starting up database 'model'.
2002-04-29 16:29:07.73 spid1 Opening file c:\mssql7\data\model.mdf.
2002-04-29 16:29:07.79 kernel udopen: Operating system error 3(系统找不到指定的路径。) during the creation/opening of physical device c:\mssql7\data\model.mdf.
2002-04-29 16:29:07.80 kernel FCB::Open failed: Could not open device c:\mssql7\data\model.mdf for virtual device number (VDN) 1.
2002-04-29 16:29:07.82 spid1 Device activation error. The physical file name 'c:\mssql7\data\model.mdf' may be incorrect.
2002-04-29 16:29:07.89 spid1 Database 'model' cannot be opened because some of the files could not be activated.
2002-04-29 16:21:43.03 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 2222: A )2002-04-29 16:21:43.05 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2002-04-29 16:21:43.05 kernel All rights reserved.
2002-04-29 16:21:43.05 kernel Logging SQL Server messages in file 'f:\MSSQL7\log\ERRORLOG'.
2002-04-29 16:21:43.05 kernel initconfig: Number of user connections limited to 32767.
2002-04-29 16:21:43.06 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2002-04-29 16:21:43.06 kernel User Mode Scheduler configured for thread processing
2002-04-29 16:21:44.09 server Directory Size: 5345
2002-04-29 16:21:44.10 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2002-04-29 16:21:44.10 spid1 failed to get sqlservr image range
2002-04-29 16:21:44.10 spid1 Starting up database 'master'.
2002-04-29 16:21:44.10 spid1 Opening file f:\MSSQL7\data\master.mdf.
2002-04-29 16:21:44.13 spid1 Opening file f:\MSSQL7\data\mastlog.ldf.
2002-04-29 16:21:44.20 spid1 Loading SQL Server's Unicode collation.
2002-04-29 16:21:44.22 spid1 Loading SQL Server's non-Unicode sort order and character set.
2002-04-29 16:21:44.25 spid1 Starting up database 'model'.
2002-04-29 16:21:44.26 spid1 Opening file c:\mssql7\data\model.mdf.
2002-04-29 16:21:44.26 kernel udopen: Operating system error 3(系统找不到指定的路径。) during the creation/opening of physical device c:\mssql7\data\model.mdf.
2002-04-29 16:21:44.26 kernel FCB::Open failed: Could not open device c:\mssql7\data\model.mdf for virtual device number (VDN) 1.
2002-04-29 16:21:44.27 spid1 Device activation error. The physical file name 'c:\mssql7\data\model.mdf' may be incorrect.
2002-04-29 16:21:44.28 spid1 Database 'model' cannot be opened because some of the files could not be activated.
谢谢大家,来者有分
2002-04-29 16:21:44.26 kernel FCB::Open failed: Could not open device c:\mssql7\data\model.mdf for virtual device number (VDN) 1.
2002-04-29 16:21:44.27 spid1 Device activation error. The physical file name 'c:\mssql7\data\model.mdf' may be incorrect.
2002-04-29 16:21:44.28 spid1 Database 'model' cannot be opened because some of the files could not be activated