Error: 17053, Severity: 16, State: 1. The operating system returned error 6851

Error: 17053, Severity: 16, State: 1.

K:\MSSQL\DATA\tempdb.mdf: Operating system error 6851(failed to retrieve text for this error. Reason: 15100) encountered.

Error: 17053, Severity: 16, State: 1.

I:\MSSQL\DATA\templog.ldf: Operating system error 6851(failed to retrieve text for this error. Reason: 15100) encountered.

The operating system returned error 6851(failed to retrieve text for this error. Reason: 15105) to SQL Server during a write at offset 0000000000000000 in file

'K:\MSSQL\DATA\tempdb.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.

The operating system returned error 6851(failed to retrieve text for this error. Reason: 15105) to SQL Server during a write at offset 0000000000000000 in file

'K:\MSSQL\DATA\tempdb.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.

Error: 5149, Severity: 16, State: 3.

When you see above ERROR messages?

This will happen for many reason,

       1. might not re-started since you created new tempdb files.

       2. Tempdb files corrupted.

SOLUTION

--MY SERVER ONLY HAVE ONE INSTANCE(LOCALHOST)..

--GO TO CONFIGURATION MANAGER AND STOP ALL SERVICES INCLUDING SQL SERVER BROWSER OR ANY OTHER

First Search for sqlservr.exe in you server just take a copy of the path

Open Cmd Prompt as an administrator my path is

-->>>> CD C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn

and Run -->>>>    Sqlservr.exe /f /c

Once Done you will see some MESSAGE like some database are recovered. CLOSE THE CMD PROMPT NOW.

Now open another cmd prompt as an administrator

NOW run -->>>>NET START MSSQLSERVER /T3608

NOW YOU WILL SEE SQL SERVER (MSSQLSERVER) IS STARTING AND SUCESSFULLY STARTED..

NOW ENTER

--->>>>>SQLCMD

--->>>>>USE MASTER

--->>>>> ALTER DATABASE TEMPDB MODIFY FILE (NAME = tempdev, FILENAME = 'C:\TEMPDB.MDF')   ---REPLACE (C:) WITH YOUR OWN PATH

--->>>>> ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'C:\Tempdblog.LDF') --REPLACE (C:) WITH YOUR OWN PATH

--->>>>>GO

NOW YOU SHOULD BE ABLE TO SEE MESSAGE

CHANGED DATABASE CONTEXT TO 'MASTER'

THE FILE "tempdev" HAS BEEN MODIFIED IN THE SYSTEM CATALOG. THE NEW PATH WILL BE USE THE NEXT TIME THE DATABASE IS STARTED.

NOW YOU GO TO CONFIGURATION MANAGER AND RESTART THE SQLSERVER..