نوشته شده توسط
Esmail Solhkhah
یه بار ایونت لاگ ویندوز رو خالی کنید بعد سعی کنید سرویس SQL SERVER رو با سرویس منیجر استارت کنید ، بعد از استارت شدن یا نشدن سرویس ایونت لاگ رو بررسی کنید ببینید داستان چیه
اگه بازم موفق نشدید میتونید PM بدید تا ریموت شم ببینم موضوع چیه
سلام
ممنون از کمکتون من ارور لوگ خود اس کیو ال رو براتو میزارم بینید شما چیزی متوجه میشید ممنون
2011-10-04 13:49:39.75 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 6.1 <X86> (Build 7600: )
2011-10-04 13:49:39.75 Server (c) 2005 Microsoft Corporation.
2011-10-04 13:49:39.75 Server All rights reserved.
2011-10-04 13:49:39.75 Server Server process ID is 2568.
2011-10-04 13:49:39.75 Server Authentication mode is WINDOWS-ONLY.
2011-10-04 13:49:39.75 Server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-10-04 13:49:39.75 Server This instance of SQL Server last reported using a process ID of 3308 at 10/4/2011 1:49:09 PM (local) 10/4/2011 10:19:09 AM (UTC). This is an informational message only; no user action is required.
2011-10-04 13:49:39.75 Server Registry startup parameters:
-d D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-10-04 13:49:39.75 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-10-04 13:49:39.75 Server Detected 2 CPUs. This is an informational message; no user action is required.
2011-10-04 13:49:39.81 Server 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.
2011-10-04 13:49:45.36 Server Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-10-04 13:49:45.42 spid7s Starting up database 'master'.
2011-10-04 13:49:45.42 spid7s Error: 5118, Severity: 16, State: 1.
2011-10-04 13:49:45.42 spid7s The file "D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2011-10-04 13:49:45.44 spid7s Error: 5118, Severity: 16, State: 1.
2011-10-04 13:49:45.44 spid7s The file "D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.