473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 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 4169
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: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.