Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bwh
Starting Member
1 Post |
 Posted - 2010-04-08 : 04:27:12
|
| Hello,i have a problem with replication a data base.I am not sure there is a problem with my sqlserver or the hardware.I hope anyone have a idea when you see my logfile?Thanks.[code]2010-04-08 07:54:32.17 Server Microsoft SQL Server 2008 (RTM) - 10.0.1763.0 (Intel X86) Sep 18 2008 21:13:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)2010-04-08 07:54:32.18 Server (c) 2005 Microsoft Corporation.2010-04-08 07:54:32.18 Server All rights reserved.2010-04-08 07:54:32.18 Server Server process ID is 1460.2010-04-08 07:54:32.18 Server Authentication mode is MIXED.2010-04-08 07:54:32.18 Server Logging SQL Server messages in file 'E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\Log\ERRORLOG'.2010-04-08 07:54:32.18 Server This instance of SQL Server last reported using a process ID of 2748 at 07.04.2010 15:33:07 (local) 07.04.2010 13:33:07 (UTC). This is an informational message only; no user action is required.2010-04-08 07:54:32.20 Server Registry startup parameters: -d E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\master.mdf -e E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\Log\ERRORLOG -l E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\mastlog.ldf2010-04-08 07:54:32.23 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.2010-04-08 07:54:32.23 Server Detected 4 CPUs. This is an informational message; no user action is required.2010-04-08 07:54:32.31 Server SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure.2010-04-08 07:54:32.82 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.2010-04-08 07:54:33.17 Server Node configuration: node 0: CPU mask: 0x0000000f Active CPU mask: 0x0000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2010-04-08 07:54:33.87 spid6s Starting up database 'master'.2010-04-08 07:54:34.29 spid6s 7 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.2010-04-08 07:54:34.39 spid6s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.2010-04-08 07:54:34.39 spid6s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.2010-04-08 07:54:35.18 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQL2008B'.2010-04-08 07:54:35.37 spid6s SQL Trace ID 1 was started by login "sa".2010-04-08 07:54:35.43 spid6s Starting up database 'mssqlsystemresource'.2010-04-08 07:54:35.48 spid6s The resource database build version is 10.00.1763. This is an informational message only. No user action is required.2010-04-08 07:54:36.93 spid10s Starting up database 'model'.2010-04-08 07:54:36.93 spid6s Server name is 'SQL2008X\SQL2008B'. This is an informational message only. No user action is required.2010-04-08 07:54:36.96 spid6s Information: Es wurden keine Sprachen mit Volltextunterstützung gefunden.2010-04-08 07:54:36.98 spid13s Starting up database 'msdb'.2010-04-08 07:54:36.98 spid16s Starting up database 'pptest'.2010-04-08 07:54:36.98 spid14s Starting up database 'ppwin'.2010-04-08 07:54:36.98 spid15s Starting up database 'pptest2'.2010-04-08 07:54:37.09 spid15s Fehler: 17204, Schweregrad: 16, Status: 1.2010-04-08 07:54:37.09 spid15s FCB::Open failed: Could not open file E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\pptest2.mdf for file number 1. OS error: 2(Das System kann die angegebene Datei nicht finden.).2010-04-08 07:54:37.15 spid15s Fehler: 5120, Schweregrad: 16, Status: 101.2010-04-08 07:54:37.15 spid15s Die physische Datei 'E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\pptest2.mdf' kann nicht geöffnet werden. Betriebssystemfehler 2: '2(Das System kann die angegebene Datei nicht finden.)'.2010-04-08 07:54:37.25 spid16s The database 'pptest' is marked RESTORING and is in a state that does not allow recovery to be run.2010-04-08 07:54:37.26 spid15s Fehler: 17207, Schweregrad: 16, Status: 1.2010-04-08 07:54:37.26 spid15s FileMgr::StartLogFiles: Operating system error 2(Das System kann die angegebene Datei nicht finden.) occurred while creating or opening file 'E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\pptest2_1.ldf'. Diagnose and correct the operating system error, and retry the operation.2010-04-08 07:54:37.26 spid15s Dateiaktivierungsfehler. Der physische Dateiname 'E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\pptest2_1.ldf' ist möglicherweise falsch.2010-04-08 07:54:37.42 Server A self-generated certificate was successfully loaded for encryption.2010-04-08 07:54:37.45 spid13s 6 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.2010-04-08 07:54:37.46 Server Server is listening on [ 'any' <ipv4> 1290].2010-04-08 07:54:37.46 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQL2008B ].2010-04-08 07:54:37.46 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQL2008B\sql\query ].2010-04-08 07:54:37.50 spid10s Clearing tempdb database.2010-04-08 07:54:37.50 Server Server is listening on [ 127.0.0.1 <ipv4> 1291].2010-04-08 07:54:37.50 Server Dedicated admin connection support was established for listening locally on port 1291.2010-04-08 07:54:37.59 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/sql2008x.bw-h.de:SQL2008B ] for the SQL Server service. 2010-04-08 07:54:37.59 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/sql2008x.bw-h.de:1290 ] for the SQL Server service. 2010-04-08 07:54:37.59 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.2010-04-08 07:54:37.64 spid13s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.2010-04-08 07:54:37.64 spid13s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.2010-04-08 07:54:38.21 spid10s Starting up database 'tempdb'.2010-04-08 07:54:38.75 spid13s The Service Broker protocol transport is disabled or not configured.2010-04-08 07:54:38.75 spid13s The Database Mirroring protocol transport is disabled or not configured.2010-04-08 07:54:38.98 spid13s Service Broker manager has started.2010-04-08 07:54:39.09 spid14s CHECKDB for database 'ppwin' finished without errors on 2010-03-28 21:00:30.180 (local time). This is an informational message only; no user action is required.2010-04-08 07:54:39.32 spid6s Recovery is complete. This is an informational message only. No user action is required.2010-04-08 07:54:41.67 spid51 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.2010-04-08 07:54:41.67 spid51 Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.2010-04-08 07:54:42.17 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.2010-04-08 07:54:42.20 spid51 Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.2010-04-08 07:54:43.14 spid51 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.2010-04-08 07:54:43.15 spid51 Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.2010-04-08 08:16:24.11 spid53 Starting up database 'ppsql'.2010-04-08 08:16:24.29 spid53 Setting database option COMPATIBILITY_LEVEL to 100 for database ppsql.2010-04-08 08:16:24.29 spid53 Setting database option ANSI_NULL_DEFAULT to OFF for database ppsql.2010-04-08 08:16:24.30 spid53 Setting database option ANSI_NULLS to OFF for database ppsql.2010-04-08 08:16:24.30 spid53 Setting database option ANSI_PADDING to OFF for database ppsql.2010-04-08 08:16:24.30 spid53 Setting database option ANSI_WARNINGS to OFF for database ppsql.2010-04-08 08:16:24.32 spid53 Setting database option ARITHABORT to OFF for database ppsql.2010-04-08 08:16:24.32 spid53 Setting database option AUTO_CLOSE to OFF for database ppsql.2010-04-08 08:16:24.32 spid53 Setting database option AUTO_CREATE_STATISTICS to ON for database ppsql.2010-04-08 08:16:24.33 spid53 Setting database option AUTO_SHRINK to OFF for database ppsql.2010-04-08 08:16:24.33 spid53 Setting database option AUTO_UPDATE_STATISTICS to ON for database ppsql.2010-04-08 08:16:24.33 spid53 Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database ppsql.2010-04-08 08:16:24.35 spid53 Setting database option CURSOR_DEFAULT to GLOBAL for database ppsql.2010-04-08 08:16:24.35 spid53 Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database ppsql.2010-04-08 08:16:24.36 spid53 Setting database option NUMERIC_ROUNDABORT to OFF for database ppsql.2010-04-08 08:16:24.38 spid53 Setting database option QUOTED_IDENTIFIER to OFF for database ppsql.2010-04-08 08:16:24.38 spid53 Setting database option RECURSIVE_TRIGGERS to OFF for database ppsql.2010-04-08 08:16:24.38 spid53 Setting database option DISABLE_BROKER to ON for database ppsql.2010-04-08 08:16:24.40 spid53 Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database ppsql.2010-04-08 08:16:24.40 spid53 Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database ppsql.2010-04-08 08:16:24.40 spid53 Setting database option PARAMETERIZATION to SIMPLE for database ppsql.2010-04-08 08:16:24.41 spid53 Setting database option READ_WRITE to ON for database ppsql.2010-04-08 08:16:24.41 spid53 Setting database option RECOVERY to FULL for database ppsql.2010-04-08 08:16:24.43 spid53 Setting database option MULTI_USER to ON for database ppsql.2010-04-08 08:16:24.43 spid53 Setting database option PAGE_VERIFY to CHECKSUM for database ppsql.2010-04-08 08:22:06.21 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\Programme\Microsoft SQL Server\MSSQL10.SQL2008B\MSSQL\DATA\ppsql.mdf] in database [<Database name is not available>] (6). The OS file handle is 0x00000644. The offset of the latest long I/O is: 0x000002ece000002010-04-08 08:23:11.13 Fehler: 3202, Schweregrad: 16, Status: 1.2010-04-08 08:23:11.13 Write on "???" failed: 27(Das Laufwerk kann den angeforderten Sektor nicht finden.)[/code |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-08 : 04:45:45
|
Looks like there is a hardware problem on drive E:
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
|
|
Replication Database