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
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
Комментариев нет:
Отправить комментарий