error 17052 : database model cannot be opened, it has been marked as suspected by recovery

Hello,
I have a annoying error with keep me off starting MSSQL Server.
I get a
error 17052 : database model cannot be opened, it has been marked as
suspected by recovery
We made a Vertias MSSQL Backup wished crashed before nd maybe this db is
locked because of this, but in order to recover that model database from a
backup we need the SQL Server in a running condition
Starting it manually with c:\Program Files\Microsft SQL
Server\binn\sqlserver -m doesn't bring it up.
In the log you get this entry:
spid5 Bypassing recovery for database 'model' because it is marked IN
LOAD.
Can anyone help?
Thanks in advance
Wolfgang R.| Hello,
|
| I have a annoying error with keep me off starting MSSQL Server.
| I get a
| error 17052 : database model cannot be opened, it has been marked as
| suspected by recovery
|
| We made a Vertias MSSQL Backup wished crashed before nd maybe this db is
| locked because of this, but in order to recover that model database from a
| backup we need the SQL Server in a running condition
|
| Starting it manually with c:\Program Files\Microsft SQL
| Server\binn\sqlserver -m doesn't bring it up.
| In the log you get this entry:
|
| spid5 Bypassing recovery for database 'model' because it is marked IN
| LOAD.
|
| Can anyone help?
| Thanks in advance
| Wolfgang R.
--
Hi Wolfgang,
Try starting SQL Server with the "-f" option: minimal configuration. That
should bypass your model database problem.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Hello Eric,
No unfortunately this doesn't help. The server isn't starting.
What is the reason for that problem? Is the DB locked or is it damaged?
Wolfgang
"Eric Cardenas" <ecard@.anonymous.com> schrieb im Newsbeitrag
news:3fzivn3wDHA.3384@.cpmsftngxa07.phx.gbl...
> | Hello,
> |
> | I have a annoying error with keep me off starting MSSQL Server.
> | I get a
> | error 17052 : database model cannot be opened, it has been marked as
> | suspected by recovery
> |
> | We made a Vertias MSSQL Backup wished crashed before nd maybe this db is
> | locked because of this, but in order to recover that model database from
a
> | backup we need the SQL Server in a running condition
> |
> | Starting it manually with c:\Program Files\Microsft SQL
> | Server\binn\sqlserver -m doesn't bring it up.
> | In the log you get this entry:
> |
> | spid5 Bypassing recovery for database 'model' because it is marked
IN
> | LOAD.
> |
> | Can anyone help?
> | Thanks in advance
> | Wolfgang R.
> --
> Hi Wolfgang,
> Try starting SQL Server with the "-f" option: minimal configuration. That
> should bypass your model database problem.
> Hope this helps,
> --
> Eric Cárdenas
> SQL Server support
>|||| Hello Eric,
|
| No unfortunately this doesn't help. The server isn't starting.
|
| What is the reason for that problem? Is the DB locked or is it damaged?
|
| Wolfgang
--
Hi Wolfgang,
Add the trace flag "-t3608" in the startup parameters. This trace flag will
bypass recovery of databases except master. You should be able to start SQL
Server after this. Then you can fix the model db problem.
Hope this helps,
--
Eric Cárdenas
SQL Server support