Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NightShyamalan
Starting Member
5 Posts |
 Posted - 2008-06-30 : 00:37:19
|
| hi, i am a reseller for kaspersky antivirus. my customer previously had purchased kaspersky corporate solution from us. For the centralized management program to work.. we need to have some kind of database to store event and all , so that the centralized management program will be able to generate reports and such.For the centralized management program to work or even start it service ... the database service and the database has to be running..i have a client who installed msde2000 sp3 .. who is now having problem with the management program due to the database problem.When i investigated the log file, i found these2008-05-20 12:19:14.09 spid51 Starting up database 'KAV'.2008-05-20 12:19:14.10 spid51 Bypassing recovery for database 'KAV' because it is marked SUSPECT.The database is marked as suspect!! .... i need to fix this issue so that i could get the kaspersky management program up and running.i have 0 expericen in sql ... i googled for solution , there is alot f website recomends to run the sp_resetstatus ... but for me , i have no idea where to start ... where do i run this command??in my command prompt? do i need to connect to my sql/msde first? Can you specialist , please guide me on how to do the sp_resetsatus ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-30 : 02:08:14
|
| There is a reason the database was marked suspect. I would suggest opening a call with Microsoft. But if you still want to reset the status, open Query Analyser and then follow this:http://doc.ddart.net/mssql/sql70/8_tr_01_1.htm |
 |
|
|
NightShyamalan
Starting Member
5 Posts |
Posted - 2008-06-30 : 02:32:56
|
| RickD , im gonna have to use query analyser? but my database is MSDE sp3 .. and i cant use query analyzer for it. The website that you refered me says step 1. Execute sp_resetstatus im asking for help on where is this sp_resetstatus ... is it a .exe?? a batch file? im sure it is simple ... but its hard for me because i have never worked with sql database. i dont even know where to start when it says Execute sp_resetstatus .. please help.. just give the steps in point form like 1)download a tool 2)run the tool 3)type bla bla bla to launch something .... an instruction like this ...can anyone help? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-30 : 03:36:26
|
| If you do not have a full fledged version of SQL Server 2000 anywhere, there are other tools you can use. Do a google search for "SQL Server 200 Client Tools".This will point to a couple of free tools, one is dbWidget - http://www.yazoosoft.comOr there is http://www.asql.biz/DbaMgr.shtmI've never used either, so can't say what they are like. |
|
|
|
NightShyamalan
Starting Member
5 Posts |
Posted - 2008-06-30 : 04:26:45
|
| so this tool should be able to help me to run the sp_resetstatus ? an option of this button would be available on these programs that you recommend?have you even done sp_resetstatus? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-30 : 06:42:14
|
| No, you would need to type the SQL into the query window.As it says in the first link I gave you, you would need to be the system admin to do this. I am not sure if you have the rights to do this, but I suspect you may not have. You would be best off raising a call or hiring a SQL expert for an hour or two. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-30 : 22:23:08
|
| >> my database is MSDE sp3 .. and i cant use query analyzer for it. You can run query with osql. By the way, sp_resetstatus will not fix db suspect issue. You should check windows event logs to find out if there are any disk related errors, and rebooting machine may solve that. |
|
|
|
|
|
|
|
|
database marked SUSPECT