General discussion


SQL Server 7.0 won't start

By mminneman ·
I'm new to SQL Server, and I have SQL Server 7.0 installed on my NT 4.0 SP6 server. Whenever the service attempts to start, it fails and leaves the following entry in the Event Viewer: "Database 'model' cannot be opened. It is in the middle of a restore." I'm not doing a restore, or even a backup. What can I do to either fix this database or tell SQL Server not to open it when the service is started?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server 7.0 won't start

by Glen_McLeod In reply to SQL Server 7.0 won't star ...

This has nothing to do with backups, it means that the 'model' database has been damaged, and that SQL Server is trying to fix it on startup and failing. You can't tell SQL Server not to open it, because it is a system DB and forms the base of all new databases.

Try starting the service with the /f switch, this acts like 'safe mode' for the database server, i.e. minimal configuration.

If that doesn't work (and I'm pretty sure that it won't), you're left with 2 options. Find a copy of the 'model' database and copy it over yours, or re-install the server.

If you have to re-install, make sure that you have copies of the data and log files for your user databases. Once the re-install is complete, you can re-attach these databases to the server by using the 'sp_attach_db' stored procedure.

Good luck.


Collapse -

SQL Server 7.0 won't start

by mminneman In reply to SQL Server 7.0 won't star ...

Glenn -- Thanks for the answer. Would you happen to have a fresh copy of this database that you could email to me?


Related Discussions

Related Forums