| Author |
Topic |
|
wdunmars
Starting Member
5 Posts |
 Posted - 2003-11-19 : 15:24:04
|
| We are using SqlSvr 7(msde) on WinNT 4.0(sp6a) server. We had a problem with a "run-a-way" transaction log, ~4Gb/1% in use. Truncate and DBCC SHRINKFILE run without error but file would not be changed.So, we figure probably corruption. We attempted a full restore(Backup Exec) which failed. Now the Sqlsvr and Sqlsvragt services are stopped and will not start. Msdtc service seems ok. SQLSERVR -c -f returns "Database 'model' cannot be opened. It is in the middle of a restore."THX Much for ANY assistance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 15:28:39
|
| Corruption, nah that would be found with DBCC CHECKDB. What do you mean Backup Exec? Why are you running SQLSERVER -c -f? Did you restore the model database? What is the error in the Event Log which says why the services won't start?A restore should never have been performed in this scenario. Why did you truncate and do DBCC SHRINKFILE if the transaction log was only 1% in use. 4GB is not large BTW.Tara |
 |
|
|
wdunmars
Starting Member
5 Posts |
Posted - 2003-11-19 : 15:37:06
|
| Backup Exec is app from Veritas. When we could not start the services, we tried to start them manually from the command-line.We had some problems with an app writing to the db. And thought maybe is was the logfile. We had this once before and were told to truncate the file and it worked. The database in question is only ~800Mb in size. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 15:42:07
|
| So you don't have a FULL backup from SQL Server, just Veritas backup?Did you check the Event Log for the error? It will tell you what the problem with the services is. What error did the application get when writing to the database? Why did you assume the log file? What database recovery model is your database set to? Truncating the transaction log is done when you are out of free space in the LDF file and the LDF can not grow anymore. You should not have to do this with a SIMPLE database recovery model or if your model is FULL and you are performing transaction log backups. But sometimes you have to. It sounds like you don't have a DBA. These types of problems would be caught be a DBA with some experience.Tara |
|
|
|
wdunmars
Starting Member
5 Posts |
Posted - 2003-11-19 : 15:55:25
|
| Yes, we only have the Veritas backup.The event log says: "The description for Event ID ( 1001 ) in Source ( SQLCTR70 ) could not be found. It contains the following insertion string(s): Cannot open the Registry Key.."We do not have a DBA,our db is small. We were doing well for last couple of years until now.Learning as we go. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 15:59:25
|
| Are there any other errors in the Event Log? Check both system and application logs. Have you ever tested the Veritas restores? This is something that should be done frequently to verify that your backups are good.A db being small does not necessarily mean you don't need a DBA. But I guess that you realize that now with your problems.Tara |
|
|
|
wdunmars
Starting Member
5 Posts |
Posted - 2003-11-19 : 16:37:26
|
| The first msg was from system event log. The following msgs is from the application event log:"17162 :SQL Server is starting at priority class 'normal'(2 CPUs detected).""The SQLServerAgent service depends on the MSSQLServer service which failed to start because of the following error: The operation completed successfully.""17052 :Database 'model' cannot be opened. It is in the middle of a restore."This is the first time I have attempted a restore. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 16:41:02
|
| Not sure what else to offer here. Sounds like you need to reinstall SQL Server, then perform restores of your databases. Hopefully your restores will work. If they don't work, you'll need to contact Veritas. As a recommendation, do not restore the database except for corruption or something similar like data accidentally deleted.Tara |
|
|
|
wdunmars
Starting Member
5 Posts |
Posted - 2003-11-19 : 16:49:27
|
| Thanks again,Tara. |
|
|
|
|
Help! Stuck In Load State