Solved

SQL 'model'DB retore is locked.

Posted on 2013-10-28
5
190 Views
Last Modified: 2013-11-01
I have a SQL Server showing that the 'Model' database is (Restoring).  However it appears to be locked and failed as it won't complete.  Does anyone know what will happen if I reboot the server while the 'Model' Database is in this condition?

I do have good backups of it in my Backup Software (Networker)

But the question is, will SQL restart if the 'Model' database is corrupt.  or is the 'Model' a requirement and will cause SQL not to start?
0
Comment
Question by:dbonis77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 15

Expert Comment

by:Ess Kay
ID: 39606676
sql will start
0
 
LVL 33

Expert Comment

by:Big Monty
ID: 39606716
the model database is just one of the example databases that comes pre-loaded with sql server. it is not a requirement to have it to run sql server, it is there just for demo purposes...
0
 

Author Comment

by:dbonis77
ID: 39606857
The confusion or question is that other posts we see, say that Model is the 'template' db abnd is required (is this new to 2008)?
0
 
LVL 33

Accepted Solution

by:
Big Monty earned 250 total points
ID: 39606870
my apologies, i totally misread your question...the MODEL database is required, as it contains all of the settings for new databases that are created:

http://technet.microsoft.com/en-us/library/ms186388.aspx

sql will start if you reboot, you just won't be able to create any new databases until you do a restore on the model database
0
 
LVL 69

Assisted Solution

by:Scott Pletcher
Scott Pletcher earned 250 total points
ID: 39606930
Don't just restart SQL Server -- that won't properly end the restore and could prevent the instance from starting, since model is required to start an instance.

Look in the error log and see if there's an error message relating to "model" and/or a db restore.

If you have a known good backup of model, you can (try to) cancel the existing restore and restore the known backup yourself.

For more details, it would help to know the specific version of SQL: 2005, 2008, etc.??
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question