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 |
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2014-07-14 : 23:58:23
|
When I tried to restore the Database I am getting this error
Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 823, Level 24, State 8, Line 1 The operating system returned error 1(failed to retrieve text for this error. Reason: 15105) to SQL Server during a write at offset 0000000000000000 in file 'D:\SQLLog\PasswordFile_log.ldf'. 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.
When I performed DBCC CHECKDB but to no avail and I have struck here.
Can anyone help me in solving this problem.
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2014-07-15 : 00:04:47
|
Also I knew this is Corrupted with SQL LDF files and I tried to remove and REcreate Database and still problem wooven around with Log Files.
And I have not found solution, please to let you know. |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-15 : 12:43:07
|
quote:
When I performed DBCC CHECKDB but to no avail and I have struck here.
What did it show?
Tara Kizer SQL Server MVP since 2007 http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|