June 26, 2014 at 3:06 am
Hi experts,
While practicing SQL DBA one of my friend by unknowingly he tried to restore the MODEL system database. then, while i am connecting to SSMS its getting the error as below
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
and while looking in to the ERROR LOG it shows that
Database 'model' cannot be opened. It is in the middle of a restore.
please help me how to solve this.
June 26, 2014 at 3:20 am
I was finding the this error in ERROR LOG file
The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.
June 26, 2014 at 4:03 am
Is SQL Server running? What happens if you try to start it?
John
June 26, 2014 at 5:17 am
its not running. Due to the database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.
June 26, 2014 at 5:20 am
OK, you need to start SQL Server in a simple configuration so that it doesn't load model and msdb, then restore model. There should be plenty of resources out there that tell you how to do that.
John
June 26, 2014 at 5:26 am
John
I am using MSSQL 2012 version. here I am not able to find configuration manager to set it into single user mode
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply