日期:2014-05-18  浏览次数:20533 次

Sql Server 2005的问题
今天手动启动本机的sqlserver2005实例,突然失败了,昨天还好好的,看了log,内容如下:

2007-07-03   10:51:58.00   Server             Microsoft   SQL   Server   2005   -   9.00.1399.06   (Intel   X86)  
Oct   14   2005   00:33:37  
Copyright   (c)   1988-2005   Microsoft   Corporation
Enterprise   Edition   on   Windows   NT   5.2   (Build   3790:   Service   Pack   2)

2007-07-03   10:51:58.00   Server             (c)   2005   Microsoft   Corporation.
2007-07-03   10:51:58.00   Server             All   rights   reserved.
2007-07-03   10:51:58.00   Server             Server   process   ID   is   3580.
2007-07-03   10:51:58.00   Server             Logging   SQL   Server   messages   in   file   'J:\Program   Files\Microsoft   SQL   Server\MSSQL.1\MSSQL\LOG\ERRORLOG '.
2007-07-03   10:51:58.00   Server             This   instance   of   SQL   Server   last   reported   using   a   process   ID   of   3060   at   2007-7-3   10:44:34   (local)   2007-7-3   2:44:34   (UTC).   This   is   an   informational   message   only;   no   user   action   is   required.
2007-07-03   10:51:58.00   Server             Registry   startup   parameters:
2007-07-03   10:51:58.00   Server               -d   J:\Program   Files\Microsoft   SQL   Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-07-03   10:51:58.00   Server               -e   J:\Program   Files\Microsoft   SQL   Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-07-03   10:51:58.00   Server               -l   J:\Program   Files\Microsoft   SQL   Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-07-03   10:51:58.01   服务器                   SQL   Server   is   starting   at   normal   priority   base   (=7).   This   is   an   informational   message   only.   No   user   action   is   required.
2007-07-03   10:51:58.01   服务器                   Detected   2   CPUs.   This   is   an   informational   message;   no   user   action   is   required.
2007-07-03   10:51:58.28   服务器                   Using   dynamic   lock   allocation.     Initial   allocation   of   2500   Lock   blocks   and   5000   Lock   Owner   blocks   per   node.     This   is   an   informational   message   only.     No   user   action   is   required.
2007-07-03   10:51:58.29   服务器                   Attempting   to   initialize   Microsoft   Distributed   Transaction   Coordinator   (MS   DTC).   This   is   an