| Author |
Topic |
|
AlanB
Starting Member
4 Posts |
 Posted - 2007-09-27 : 18:31:59
|
| I am running SQL Server 2000 and for some reason the service has stopped and will not start. We need to do a restore to a database with Veritas 9.1, but cannot do it because the service has stopped. Any thoughts on how to get the service started again?AlanB |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-27 : 19:11:54
|
| Check the Application Log in Event Viewer for the specific error. If there are too many entries to weed through, try starting the service, then when you get the error, check the AppLog. The error should be at the top or near it.You can post the error here if you'd like help.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
AlanB
Starting Member
4 Posts |
Posted - 2007-09-27 : 19:27:02
|
| This is the event viewer app error:"error 17055Database 'model' cannot be opened. It is in the middle of a restore." This is a copy of the SQL error log.2007-09-27 18:17:21.00 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)2007-09-27 18:17:21.00 server Copyright (C) 1988-2002 Microsoft Corporation.2007-09-27 18:17:21.00 server All rights reserved.2007-09-27 18:17:21.00 server Server Process ID is 4804.2007-09-27 18:17:21.00 server Logging SQL Server messages in file 'e:\sqldata\MSSQL\log\ERRORLOG'.2007-09-27 18:17:21.02 server SQL Server is starting at priority class 'normal'(2 CPUs detected).2007-09-27 18:17:21.11 server SQL Server configured for thread mode processing.2007-09-27 18:17:21.13 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.2007-09-27 18:17:21.16 server Attempting to initialize Distributed Transaction Coordinator.2007-09-27 18:17:22.21 spid3 Starting up database 'master'.2007-09-27 18:17:22.22 server Using 'SSNETLIB.DLL' version '8.0.766'.2007-09-27 18:17:22.22 spid5 Starting up database 'model'.2007-09-27 18:17:22.22 spid3 Server name is 'GA1CDC02'.2007-09-27 18:17:22.22 spid8 Starting up database 'msdb'.2007-09-27 18:17:22.22 spid9 Starting up database 'pubs'.2007-09-27 18:17:22.22 spid5 Bypassing recovery for database 'model' because it is marked IN LOAD.2007-09-27 18:17:22.24 spid5 Database 'model' cannot be opened. It is in the middle of a restore. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 20:07:07
|
That's a bit scary  Was someone trying to Restore the MODEL database?Can you start the service manually with the -m option?Kristen |
|
|
|
AlanB
Starting Member
4 Posts |
Posted - 2007-09-27 : 20:46:19
|
| How do you start it manually? I have never done it before |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 21:07:32
|
| Should be something like this:Open a Command Line window on the Server then:CD C:\Program Files\Microsoft SQL Server\MSSQL\BinnSQLSERVR.EXE -mSee "Starting SQL Server Manually" in Books Online.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 00:46:48
|
| Any restore job running? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-28 : 03:04:55
|
| Its just been restart rmiao, or am I missing something? Looks to me like it was shutdown in the middle of a restore, and given how small MODEL normally is I wonder if something "big" was being restored to it by mistake?By the by, what size are the model.mdf/ldf physical files?Kristen |
|
|
|
AlanB
Starting Member
4 Posts |
Posted - 2007-09-28 : 07:33:14
|
| The model.mdf file is 640 KB. I could not locate the model.ldf file in C:\Program Files\Microsoft SQL Server\MSSQL\Data I appreciate your helpAlan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-28 : 10:39:37
|
| Mine is 640k too. The ldf file is modellog.ldf - 768K here.So doesn't seem that someone has restored a "real" database over the top of it, as I'm sure it would be bigger than that.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 22:48:15
|
| Copy model.ldf file from other server then try start sql again. By the way, did you put db log files in another location? |
|
|
|
|
Starting MSSQL server service to perform restore