vergammelte
Aktives Mitglied
Hallo,
habe gerade eben festgestellt, das wenn ich ein Backup von der Wawi machen will ich immer folgenden fehler bekomme:
Fehler beim Lesen auf 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf': 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.)
BACKUP DATABASE wird fehlerbedingt beendet.
SQL Server: ".\JTLWAWI".
hier ein auszug aus der log:
WAIW version: 099923
Windows 8.1
SQL 2012
Hoffe das mir jemand weiterhelfen kann so das ich wieder Backups erstellen kann
Vielen Dank.
habe gerade eben festgestellt, das wenn ich ein Backup von der Wawi machen will ich immer folgenden fehler bekomme:
Fehler beim Lesen auf 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf': 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.)
BACKUP DATABASE wird fehlerbedingt beendet.
SQL Server: ".\JTLWAWI".
hier ein auszug aus der log:
Code:
2015-09-04 22:35:23.59 spid58 Starting up database 'ReportServer$JTLWAWITempDB'.
2015-09-04 22:37:14.02 spid58 A read of the file 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf:MSSQL_DBCC8' at offset 0x000000fcbd0000 succeeded after failing 1 time(s) with error: 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-09-04 22:37:31.56 spid58 Fehler: 823, Schweregrad: 24, Status: 2.
2015-09-04 22:37:31.56 spid58 The operating system returned error 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.) to SQL Server during a Lesen at offset 0x000000fcbd2000 in file 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf:MSSQL_DBCC8'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-09-04 22:37:31.57 spid58 DBCC CHECKDB (eazybusiness) WITH no_infomsgs, tableresults executed by sa terminated abnormally due to error state 6. Elapsed time: 0 hours 2 minutes 2 seconds.
2015-09-04 22:44:32.54 spid53 Starting up database 'ReportServer$JTLWAWITempDB'.
2015-09-04 22:52:55.95 spid55 Starting up database 'ReportServer$JTLWAWITempDB'.
2015-09-04 22:54:32.54 spid56 Starting up database 'ReportServer$JTLWAWITempDB'.
2015-09-04 22:54:45.45 spid55 A read of the file 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf:MSSQL_DBCC8' at offset 0x000000fcbd0000 succeeded after failing 1 time(s) with error: 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-09-04 22:55:02.97 spid55 Fehler: 823, Schweregrad: 24, Status: 2.
2015-09-04 22:55:02.97 spid55 The operating system returned error 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.) to SQL Server during a Lesen at offset 0x000000fcbd2000 in file 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf:MSSQL_DBCC8'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-09-04 22:55:02.98 spid55 DBCC CHECKDB (eazybusiness) WITH no_infomsgs, tableresults executed by sa terminated abnormally due to error state 6. Elapsed time: 0 hours 2 minutes 3 seconds.
2015-09-04 22:58:03.90 spid51 Starting up database 'eazybusiness'.
2015-09-04 22:58:04.06 spid51 Starting up database 'ReportServer$JTLWAWITempDB'.
2015-09-04 22:58:07.68 spid55 Starting up database 'eazybusiness'.
2015-09-04 22:58:36.37 spid55 Setting database option SINGLE_USER to ON for database 'eazybusiness'.
2015-09-04 22:58:53.54 spid54 Starting up database 'eazybusiness'.
2015-09-04 22:58:56.19 Logon Fehler: 18456, Schweregrad: 14, Status: 38.
2015-09-04 22:58:56.19 Logon Login failed for user 'Server-PC\Daniel'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank 'eazybusiness'. [CLIENT: <local machine>]
2015-09-04 22:58:58.37 Logon Fehler: 18456, Schweregrad: 14, Status: 38.
2015-09-04 22:58:58.37 Logon Login failed for user 'Server-PC\Daniel'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank 'eazybusiness'. [CLIENT: <local machine>]
2015-09-04 23:01:18.26 spid54 A read of the file 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf' at offset 0x000000fcbd0000 succeeded after failing 1 time(s) with error: 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-09-04 23:01:47.27 spid6s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf] in database [eazybusiness] (7). The OS file handle is 0x0000000000000AE8. The offset of the latest long I/O is: 0x000000fcbd2000
2015-09-04 23:02:05.74 spid54 Fehler: 823, Schweregrad: 24, Status: 2.
2015-09-04 23:02:05.74 spid54 The operating system returned error 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.) to SQL Server during a Lesen at offset 0x000000fcbd2000 in file 'c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-09-04 23:02:06.77 spid54 DBCC CHECKDB (eazybusiness, repair_rebuild) executed by Server-PC\Daniel terminated abnormally due to error state 6. Elapsed time: 0 hours 2 minutes 35 seconds.
2015-09-04 23:03:04.28 Backup Fehler: 3041, Schweregrad: 16, Status: 1.
2015-09-04 23:03:04.28 Backup BACKUP failed to complete the command BACKUP DATABASE eazybusiness. Check the backup application log for detailed messages.
2015-09-04 23:03:22.77 spid55 Starting up database 'eazybusiness'.
2015-09-04 23:04:24.83 Backup Fehler: 3203, Schweregrad: 16, Status: 1.
2015-09-04 23:04:24.83 Backup Read on "c:\Program Files\Microsoft SQL Server\MSSQL11.JTLWAWI\MSSQL\DATA\eazybusiness.mdf" failed: 1117(Die Anforderung konnte wegen eines E/A-Gerätefehlers nicht ausgeführt werden.)
2015-09-04 23:04:24.85 Backup Fehler: 3041, Schweregrad: 16, Status: 1.
2015-09-04 23:04:24.85 Backup BACKUP failed to complete the command BACKUP DATABASE eazybusiness. Check the backup application log for detailed messages.
2015-09-04 23:04:32.54 spid54 Starting up database 'ReportServer$JTLWAWITempDB'.
2015-09-04 23:07:49.05 spid55 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2015-09-04 23:07:49.06 spid55 Using 'xplog70.dll' version '2011.110.5058' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2015-09-04 23:09:59.33 spid54 Starting up database 'eazybusiness'.
2015-09-04 23:10:15.92 spid54 Setting database option MULTI_USER to ON for database 'eazybusiness'.
2015-09-04 23:13:01.70 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2015-09-04 23:13:03.03 spid16s Service Broker manager has shut down.
2015-09-04 23:13:03.03 spid16s Error: 17054, Severity: 16, State: 1.
2015-09-04 23:13:03.03 spid16s The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
2015-09-04 23:13:03.03 spid7s .NET Framework runtime has been stopped.
2015-09-04 23:13:03.10 spid7s SQL Server shutdown has been initiated
2015-09-04 23:13:03.10 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
WAIW version: 099923
Windows 8.1
SQL 2012
Hoffe das mir jemand weiterhelfen kann so das ich wieder Backups erstellen kann
Vielen Dank.