Post reply

Error starting SQLServer services.. HELP!

  • August 23, 2004 at 7:54 am

    #83707

    Hi,

    I have a database (DB) in SQLServer97 which is huge and I was trying to move it to another server.

    In the Server1, I stopped the SQL services and have tried copying the file.DAT to Server2, but I left the same file in Server1.

    When I try to start again the services in Server1, I receive this message:

    "Could not start the MSSQLServer service

    Error 2140: An internal Windows NT error occurred."

    Now, I can't access the data

    Please, I need help to solve this problem, it's urgent. Thank you!

  • August 24, 2004 at 3:44 am

    #520278

    The Windows Event Log could give you more details of why SQL will not start. 

    If this does not help, add a startup parameter of -T3608 and try again.  (Search for 3608 in the SQL KB on the web for details of how to add this paremeter with Regedit.)  3608 will disable restart processing for everything apart from Master, and can get SQL running in most situations.  If SQL starts, look in the SQL error log for clues on what the underlying problem is, and fix it.  You eventually need to get SQL running without -T3608 before you let real users access the databases.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply