Solved

SQL 'model'DB retore is locked.

Posted on 2013-10-28
5
181 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
5 Comments
 
LVL 15

Expert Comment

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

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 32

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:ScottPletcher
ScottPletcher 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now