SQL Engine stopped

Navigation
1

Some of you have seen this error:

  

The log scan number (35: 295: 1) passed to log scan in database 'model'   is not valid This error may indicate data corruption or that the log   file (.ldf) does not match the data file (.mdf). If this error   occurred during replication, re-create the publication. Otherwise,   restore from backup if the problem results in a failure   startup.

This error appears because the SQL Engine is stopped, and I have not been able to make it work in any way.

When I want to connect to the engine, I get the following error:

I hope you can help me.

    
asked by Julius Belmonth Gonzalez 29.09.2016 в 00:14
source

3 answers

2

What I have done is:

  • I press the start button and type sql.
  • Shows you sql server configuration manager
  • Right click on it and run it as administrator
  • You will see the services of sql server and they will appear stopped or stopped.
  • You right click on sql server Agent and put stop or stop.
  • Then you start or turn on each of them, you have to put it on start or turn on.

    • Greetings!

        
    answered by 03.10.2016 в 23:14
    0

    Execute the following commands and update your question with the result they give you: 

    ALTER DATABASE nombreDeTuBaseDeDatos SET EMERGENCY  
DBCC CHECKDB (nombreDeTuBaseDeDatos) WITH ALL_ERRORMSGS

    I will update the answer according to what you find.

        
    answered by 29.09.2016 в 00:30
    0

    I would do the following:

  • I stop the services.
  • I go to the sql data folder and copy all the files in the databases to another location.
  • I uninstall the sql and reinstall it.

    • This has happened to me several times in windows 7 and windows server 2008 and apparently (I'm not 100% sure) there is a windows update that stops the services and then there is no way to restart them again rather than reinstalling.

        
    answered by 03.10.2016 в 22:14
    How can I know if a server allows JSONP or CORS Error with Combobox ItemStateChanged