In the file 'E: \ Microsoft SQL Server \ MSSQL. 1 \ MSSQL \ Data \ mfdata MDF', the location of the offset 0 x000001fb248000 perform during the reading, the operating system has to SQL Server returned an error 1117 (because of I/O device error, unable to run this request,), SQL Server error logs and other messages in the system event logs may provide more detailed information, this is a serious threat to the integrity of the database system level error conditions, must immediately correct, please perform a complete database consistency check (DBCC CHECKDB), the error can be caused by many factors; For more information, please refer to the SQL Server books online,
2, and then execute DBCC CHECKDB
3, manual backup tips as well as the above 1 is... Have to SQL Server returned an error 1117 (because of I/O device error, unable to run this request,...
What causes, how should solve? Thank you
CodePudding user response:
Should be database data file is damaged, repair the database to try and put the following statement inside hydee try replacing your database name,Sp_dboption 'hydee', 'single user', 'true'
Go
DBCC checkdb (' hydee ', 'REPAIR_REBUILD')
Go
Sp_dboption 'hydee', 'single user', 'false'
-- -- -- -- -- -- -- -- -- --
Sp_dboption 'hydee', 'single user', 'true'
Go
DBCC checkdb (' hydee ', 'REPAIR_FAST')
Go
Sp_dboption 'hydee', 'single user', 'false'
-- -- -- -- -- -- -- -- -- -- -- -- --
Sp_dboption 'hydee', 'single user', 'true'
Go
DBCC checkdb (' hydee ', 'REPAIR_ALLOW_DATA_LOSS')
Go
Sp_dboption 'hydee', 'single user', 'false'