| Author |
Topic |
|
billey100
Starting Member
12 Posts |
 Posted - 2007-04-25 : 14:34:07
|
| Help! I just took over for a new company and after logging in to one of the servers I tried to click on the Symantec Backup Exec on the desktop. It failed and said that none of the services are started, looking in my services I can not get any of the services related to sql to start. In the bottom right hand corner in the system tray I have a red dot on the sql server and it is stopped. All the event logs say that: During redoing of a logged operation in database 'master', an error occurred at log record ID (199:200:5). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 14:36:33
|
| Do you have backups for the master database? Are you able to start SQL Server in single server mode via a cmd window?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-25 : 14:42:46
|
| Ok I forgot to mention I know nothing of SQL, so you will have to go slow and spell things out for me. I have been here a week and the person that was here before me has been gone for 5 weeks, so 1. I dont know if there is a backup? 2. I don't know where to look and 3. I don't know how to get in via cmd line. I am really sorry |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 14:47:37
|
| I would suggest contacting Microsoft directly then as this would require DBA experience. Micrsoft will be able to walk you through it step by step.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-25 : 15:04:11
|
| What does that entail as far as fees, do they charge a one time support fee or something? It is a dell server and is under warranty for hardware and I can purchase an one time incident software support deal, but would I be better off with MS? Thanks for your help this forum is great. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 15:25:47
|
| I doubt Dell can help you with a SQL Server database. Yes Microsoft will charge you. I believe it's around 250 bucks per case.You could probably solve this on your own if you were able to locate the backups. Let us know if you find them.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-25 : 15:30:59
|
| When you say backups do you mean something that would have been backed up each night with our Backup software, or is there something inside sql folders that I can look for? I ask becasue I can't get anything off the backup tapes b/c I can't open the backup app, bb/c sql isn't running. It's kinda like going in circles... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 15:41:24
|
| We backup our databases to disk using SQL Server. There is no specific folder where they go. Whoever set it up decides where they go.We do not leverage Tape backup software to backup the databases directly. Some people do though. We do sweep our SQL Server backup files to tape with tape backup software though. So I can't tell you where to look as I don't know how the databases were being backed up.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-25 : 15:41:39
|
| Let me ask something else, in my programs I have Microsoft SQL Server 2005 and I also have Microsoft SQL server are they two seperate things? In my D drive folders I have a SQL Server Databases folder with a MSSQL folder under that which then has backup, data, logs, etc. Of course the backup folder is empty. Now under my C drive I have a folder under Program Files that has Microsoft SQL Server and under that I have folders called 80, 90, MSSQL and MSSQL.1? All of them have error logs from today, do I have two versions of SQL running or did they just upgrade from 2000 to 2005? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 15:42:56
|
| Check Services in Control Panel..Admin Tools. List all services that start with MSSQL and SQL.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-25 : 16:35:21
|
| Seems the machine has both sql2k and sql2k5 installed. You can open errorlog with text editor, check what you have in those logs. |
|
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-25 : 16:53:30
|
| I have MSSQLSERVER, SQL Server (BKUPEXEC), SQL Server Active Directory Helper, SQL Server Browser, SQL Server VSS Writer, SQLSERVERAGENT, that's all that I can see. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-25 : 16:57:37
|
| Are they running? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 16:58:16
|
| You have both SQL Server 2000 and SQL Server 2005 installed. The SQL Servers are:YourHostName <-- SQL Server 2000 default instanceYourHostName\BKUPEXEC <-- SQL Server 2005 named instance (probably used for Backup Exec tape backup software)Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-26 : 08:34:47
|
| No none of them are running and I can't get any of the to start at all, so is it safe to remove the 2000? I mean I don't know if there is something using both or is that not even possible and the 2000 is just leftover and wasn't installed? |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-04-26 : 11:07:07
|
| Do you have a secondary server running SQL? Have a look through the MSSQL directories, especailly the \Backups sur-dir, as that is most likely to be where backups are going to (but not guaranteed). Mook for files named master.bak, msdb.bak etc. Again, the .bak is not guaranteed to the extensions, but those are the dfaults.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 13:09:57
|
| If you can't get those sql instances start, no one can use them then. You said errorlog files have current timestamp, can you look at those errorlog files to see what kind of messages in them? |
|
|
|
billey100
Starting Member
12 Posts |
Posted - 2007-04-27 : 13:46:12
|
| Ok here is what I found out after have some time to invesitgate... I called symantec and got support on the Backup Exec, now when installed it intalls its own version of sql (sql express) which is in my add/remove programs as MSXML. Now that had gone bad and there was no saving it and no backup of it but I am not out much it is a small server and only had on backup job on it that I should be able to rebuild. Secondly I also found out from them that the SQL 2000 and the SQL 2005 have nothing to do with Backup. So it is still not working but here is the thing I don't think anything that was using it is still here? I talked with the guy before me and he said as far as he knew the only two things using it were Altiris and WSUS, both we are not using anymore and I took them off after SQL crashed just to clean up the server. So my lingering question is now how to make sure I am defintetly not using SQL at all and can I just remove it? Keep in mind that it has been down for about a week and no one seems to have been affected at all. If I do blow them off the box should I burn all the folders related to SQL on a disk just in case I need to reload it? I am guessing it doens't matter if I blow them off becasue they aren't working anyway and then maybe I would get some different errors in event viewer of something that may be lloking for it? Sorry for the long post and thanks for the help. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 16:55:34
|
| I'll keep all db files somewhere just in case, can attach them to sql server when needed. |
|
|
|
|
mssqlserver will not start