Dmitry Gorchilin digger.dp.ua

Такая вот творческая задача получилась. Начал поднимать сервер ***, он падает. Оказывается диск H недоступен. Есть диск Д, в логе
 
2021-05-27 10:43:00.03 spid7s      CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file 'H:\TempDB\tempdb.mdf'.
2021-05-27 10:43:00.03 spid7s      Error: 17204, Severity: 16, State: 1.
2021-05-27 10:43:00.03 spid7s      FCB::Open failed: Could not open file H:\TempDB\tempdb.mdf for file number 1.  OS error: 3(The system cannot find the path specified.).
2021-05-27 10:43:00.03 spid7s      Error: 5120, Severity: 16, State: 101.
2021-05-27 10:43:00.03 spid7s      Unable to open the physical file "H:\TempDB\tempdb.mdf". Operating system error 3: "3(The system cannot find the path specified.)".
2021-05-27 10:43:00.03 spid7s      Error: 1802, Severity: 16, State: 4.
2021-05-27 10:43:00.03 spid7s      CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2021-05-27 10:43:00.03 spid7s      Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
2021-05-27 10:43:00.03 spid7s      SQL Server shutdown has been initiated
 
Что сделал- запустил в аварийном режиме
 

NET START MSSQLSERVER /f /T3608
 
и в sqlcmd выполнил

USE master;
GO

ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = 'D:\DATA\tempdb.mdf');
GO

ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = 'D:\DATA\templog.ldf');
GO