model database locked

I receive the following message in the Event log when
trying to start SQLSERVER service...
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:11/06/2004
Time:17:45:05
User:N/A
Computer:NWK-S-SQL
Description:
17052 :
Database 'model' cannot be opened. It is in the middle of
a restore.
Data:
0000: 9c 42 00 00 0a 00 00 00 œB.....
0008: 0a 00 00 00 4e 00 57 00 ...N.W.
0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
0018: 53 00 51 00 4c 00 00 00 S.Q.L...
0020: 00 00 00 00 ...
This is preventing the service from starting... any
suggestions on how to resolve this? Unfortunately I do not
know how the database got into this state
After a reboot of the server, several databases came back
listed as 'loading' (in a restore mode) for no aparent
reason... after a further reboot... this!
all suggestions greatfully recieved
cheers
Keith
Hi,
If the model database is in middle of restore you can start sql server in
mimimal mode or Single user mode. To over come
thisadd 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. After this try to restore the model
database from a backup.
(-T3608 can be added from control panel -- Admin tools-- services -- MSSQL
Server --Stop MSSQL Service-- In the parameter give the values -T3608--
Start MSSQL Server service)
If you still have issues then; stop SQL server service and then:-
1. COpy the exising model.mdf and modellog.ldf to a safe place
2. Overwriting model.mdf and modellog.ldf with the files in SQL Server CD,
and then try to startup the service.
Thanks
Hari
MCDBA
"Keith Newton" <keith.newton@.riba-enterprises.com> wrote in message
news:1b12c01c44fe1$fa128490$a601280a@.phx.gbl...
> I receive the following message in the Event log when
> trying to start SQLSERVER service...
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 11/06/2004
> Time: 17:45:05
> User: N/A
> Computer: NWK-S-SQL
> Description:
> 17052 :
> Database 'model' cannot be opened. It is in the middle of
> a restore.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 œB.....
> 0008: 0a 00 00 00 4e 00 57 00 ...N.W.
> 0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
> 0018: 53 00 51 00 4c 00 00 00 S.Q.L...
> 0020: 00 00 00 00 ...
> This is preventing the service from starting... any
> suggestions on how to resolve this? Unfortunately I do not
> know how the database got into this state
> After a reboot of the server, several databases came back
> listed as 'loading' (in a restore mode) for no aparent
> reason... after a further reboot... this!
> all suggestions greatfully recieved
> cheers
> Keith