By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

Error starting MS SQL 17051

P: 2
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
Share this Question
Share on Google+
1 Reply


P: 1
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

Post your reply

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