472,779 Members | 2,524 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,779 software developers and data experts.

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"
Jun 16 '18 #1
1 4133
a. ALTER DATABASE DB-NAME SET EMERGENCY
b. ALTER DATABASE DB-NAME SET SINGLE_USER
c. DBCC CHECKDB (DB-NAME, REPAIR_ALLOW_DATA_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
Jun 27 '18 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Addam Webber | last post by:
Anyone, When I start my .net developer environment I get this error. Package 'VSLog Package' failed to load. I have searched Microsoft Knowledge base but there seams to be no help on this. Does...
0
by: Max | last post by:
Hi Folks, I'm received this error on starting Control Center from the Start menu.... db2javit.dll This file does not have a program associated with it for performing this action. Create an...
0
by: Agiato | last post by:
Hello all, I am encountering an error when I choose to create a C# web project. Here is the error message: http://localhost/whatever. 'HTTP/1.1 500 Server Error'. I am using VS.NET 2003 on a...
0
by: Mark | last post by:
I believe this is an ASP.Net 2 framework problem because the ASP Admin Service fails to start with the message - "Error 2 - The system cannot find the file specified" I get the following error...
2
by: jcrouse | last post by:
I moved a bunch of code and variable declaration around to make things a little more efficient. Now when i try and run the app I get the following error: An unhandled exception of type...
3
by: molemoore | last post by:
When I'm trying to start a new VB.Net Windows application I'm getting an error that the "Automation server can create object". The project is created but without a form. When I try to add a form I...
1
by: amirmira | last post by:
I have developed a service in VB.NET that accepts startup parameters. Everything works fine on my machine, but when I deploy the service on another machine, I get the following error when I try to...
0
by: zzhou | last post by:
Hi When I call my DLL, after some dialog was diplay , I got next error "Starting a second message loop on a single thread is not a valid operation. Use Form.ShowDialog instead." What was...
0
by: Dominic | last post by:
Every thing work fine when I am not starting process as another user. When I am starting process as another user, the authentication is working (I can see it in my workstation security log), but...
3
vikas1111
by: vikas1111 | last post by:
I have installed apache2.2 on my windows xp system. I even have IISw3 running on my system, My problem is with Apache, every day i have to restart my system 20 times in order to start apache. I get...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.