Поиск по этому блогу

суббота, 18 мая 2013 г.

SQL tempDB disk failure

After disk fail SQL server even didnt want to start. What should we do:
1) Open services.msc
2) Find service "SQL Server (MSSQLSERVER) - double click. Add Start parameter "-m" and press Start.


3) After SQL server launch, open Management Studio. Create and exequte query:
USE master
ALTER DATABASE tempdb
MODIFY file(
name = tempdev,
filename = N'D:\tempDB\tempdb.mdf')
GO

ALTER DATABASE tempdb
MODIFY file(
name = templog,
filename = N'D:\tempDB\templog.ldf')
GO

where D:\tempDB\ - new folder for tempDB.

4) Restart SQL server service, without "-m" parameter.
Done.

Related article 

Комментариев нет:

Отправить комментарий