October 25, 2014 at 7:39 pm
Hi Experts,
I have restored the master db in single user mode.
---
Processed 440 pages for database 'master', file 'master' on file 1.
Processed 3 pages for database 'master', file 'mastlog' on file 1.
The master database has been successfully restored. Shutting down SQL Server.
SQL Server is terminating this process.
---
I removed single user mode parameter(-m;)
When I start SQL Server in configuration manager getting below error
---
The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details
--
Can you please help me on this.
Thanks in advance
October 27, 2014 at 12:00 am
On single user mode, were you able to connected to user DB's?.
Regards
Durai Nagarajan
October 27, 2014 at 1:30 am
Whats the error in windows error log???
October 27, 2014 at 2:44 am
Find the latest SQL error log. Post it here (all of it)
Ref: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2014 at 7:46 pm
Hi ,
PFA is the Last few lines of Error log.
October 27, 2014 at 9:46 pm
The error is pretty clear the model database cannot be opened.
Check the path in the errorlog, is it correct, are the permissions correct on the folder?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2014 at 10:14 pm
i have installed SQL Server instance in E drive(E:\program files\MSSQL12.SQL2014_4\MSSQL\DATA),
restored Master db in E drive it self ..
but I am not sure why error log shows "C:\Program Files\Microsoft SQL Server\MSSQL12.LIVE\MSSQL\DATA\model.mdf"
E drive already has model db mdf and ldf..
E:\program files\MSSQL12.SQL2014_4\MSSQL\DATA\model.mdf
E:\program files\MSSQL12.SQL2014_4\MSSQL\DATA\modellog.ldf
October 27, 2014 at 10:36 pm
Well, irrespective of where you think model is, the C drive is where the service is looking.
Has this master db backup come from this server originally?
Check the service startup parameters and post details back.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply