SQL server 2008 R2 install error
-
Hi,
I am trying install SQL 2008 R2 in windows 7 OS 32 bit, throwing below error
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Please guide me how to resolve this? Thanks!
log file :
2011-08-17 12:34:23.09 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
Apr 2 2010 15:53:02
Copyright (c) Microsoft Corporation
Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
2011-08-17 12:34:23.09 Server (c) Microsoft Corporation.
2011-08-17 12:34:23.09 Server All rights reserved.
2011-08-17 12:34:23.09 Server Server process ID is 4808.
2011-08-17 12:34:23.09 Server System Manufacturer: 'Dell Inc.', System Model: 'Inspiron 1545'.
2011-08-17 12:34:23.09 Server Authentication mode is WINDOWS-ONLY.
2011-08-17 12:34:23.09 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-08-17 12:34:23.09 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-08-17 12:34:23.09 Server Command Line Startup Parameters:
-m SqlSetup
-f
-Q
-q SQL_Latin1_General_CP1_CI_AS
-T 4022
-T 4010
-T 3659
-T 3610
2011-08-17 12:34:23.21 Server Warning: The server instance was started using minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically. After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the server.
2011-08-17 12:34:23.21 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-08-17 12:34:23.21 Server Detected 2 CPUs. This is an informational message; no user action is required.
2011-08-17 12:34:23.31 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2011-08-17 12:34:23.32 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-08-17 12:34:23.54 Server Node configuration: node 0: CPU mask: 0x00000003:0 Active CPU mask: 0x00000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-08-17 12:34:23.55 Server Support for distributed transactions was not enabled for this instance of the Database Engine because it was started using the minimal configuration option. This is an informational message only. No user action is required.
2011-08-17 12:34:23.58 spid6s Warning ******************
2011-08-17 12:34:23.63 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 1396, committed (KB): 18616, memory utilization: 7%.
2011-08-17 12:34:23.63 spid6s SQL Server started in single-user mode. This an informational message only. No user action is required.
2011-08-17 12:34:23.80 spid6s Starting up database 'master'.
2011-08-17 12:34:23.89 spid6s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-08-17 12:34:24.09 spid6s SQL Server was started using the -f flag. SQL Server Audit is disabled. This is an informational message. No user action is required.
2011-08-17 12:34:24.10 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2011-08-17 12:34:24.10 spid6s Server started with '-f' option. Auditing will not be started. This is an informational message only; no user action is required.
2011-08-17 12:34:24.10 spid6s Starting up database 'mssqlsystemresource'.
2011-08-17 12:34:24.14 spid6s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2011-08-17 12:34:24.40 spid6s Error: 15209, Severity: 16, State: 1.
2011-08-17 12:34:24.40 spid6s An error occurred during encryption.
-
Try to start SQL with this
sqlservr.exe -d"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf"-e"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG"
–l"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" -m -c -syoursqlinstance
-
The server instance was started using minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically. After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the server.
"you should change the appropriate server option value or values, stop, and then restart the server."
Restart as in the above post
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply