question

mickyd avatar image
mickyd asked

help - problems with Model database

Hi everyone need some urgent advice on this one. Got a situation where a server is displaying these errors in the SQL error log. the model DB shows as restoring, when SQL started with /T3608. the database 'model' is marked RESTORING and is in a state that does not allow recovery to be run. 2011-07-11 10:45:37.09 spid9s Error: 927, Severity: 14, State: 2. 2011-07-11 10:45:37.09 spid9s Database 'model' cannot be opened. It is in the middle of a restore. 2011-07-11 10:45:37.10 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized. 2011-07-11 10:45:37.10 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. had a look on line , but a bit stuck on how to proceed. Can anyone offer any adivce or point me in the right direction ? there is plenty of disk space avaiable. many thanks in advance.
system-databases
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
Why are you using that trace flag? It looks like it skips running recovery on any databases except master, which would kind of explain why model is still marked as restoring. Only to be used when specifically told to by Microsoft support: [ http://sqlserverpedia.com/wiki/Trace_Flags][1] [1]: http://sqlserverpedia.com/wiki/Trace_Flags
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.