Error starting MS SQL 17051

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • psammite
    New Member
    • Jun 2018
    • 2

    Error starting MS SQL 17051

    Error trying to start MS SQL Server 2008 R2 server service
    ""The SQL Server service could not be started on SQL SERVER. Details are provided in the system event log. If this service is not developed by Microsoft, contact the developer of the service, and report the error code 17051 specific to this service"
  • goshawk
    New Member
    • Jun 2018
    • 1

    #2
    a. ALTER DATABASE DB-NAME SET EMERGENCY
    b. ALTER DATABASE DB-NAME SET SINGLE_USER
    c. DBCC CHECKDB (DB-NAME, REPAIR_ALLOW_DA TA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS
    d. ALTER DATABASE DB-NAME SET ONLINE
    e. ALTER database DB-NAME set MULTI_USER
    Description:
    a. Set database to emergency mode
    b. Set database to single user mode
    c. Check database and repair with allow data loss
    d. Back database to online mode from emergency mode
    e. Set database to multi user mode
    Last edited by Rabbit; Jun 27 '18, 04:45 PM. Reason: advertisement link removed

    Comment

    Working...