locked
MS SQL Server 14 recovery RRS feed

  • Question

  • Hello couple days ago my pc with Ms SQL Server 14 broke, probably due to latest updates, well I installed on new hardrive new copy of windows and copied server and data from: "D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER" to "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER" now since sql server requires services to run I installed also:

    Using powershell:

    New-Service -Name "SQL Server (MSSQLSERVER2)" -BinaryPathName "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn\sqlservr.exe -sMSSQLSERVER"

    AND

    New-Service -Name "SQL Server CEIP service (MSSQLSERVER2)" -BinaryPathName "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn\sqlceip.exe -Service"

    Launching both services only SQL Server CEIP service (MSSQLSERVER2) launches without problem but SQL Server (MSSQLSERVER2) throws error

    Windows could not start the SQL Server (MSSQLSERVER2) on Local Computer Error 1067: The process terminated unexpectedly

    Event viewer shows this:

    Faulting application name: sqlservr.exe, version: 2017.140.2027.2, time stamp: 0x5d04c374
    Faulting module name: KERNELBASE.dll, version: 10.0.18362.476, time stamp: 0x83c3d83a
    Exception code: 0xc06d007e
    Fault offset: 0x000000000003a839
    Faulting process id: 0x1718
    Faulting application start time: 0x01d5c782d12cad8f
    Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
    Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
    Report Id: be48a555-f404-412e-a8c6-ddc06bb60a36
    Faulting package full name: 
    Faulting package-relative application ID: 

    How I suppose to start SQL server?

    Friday, January 10, 2020 6:57 AM

All replies