Backup Database marked as "SUSPECT" by the SQL recovery

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

Backup Database marked as "SUSPECT" by the SQL recovery

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Networking & Security] >> GFI EventsManager >> Backup Database marked as "SUSPECT" by the SQL recovery

Page: [1]

Message

<< Older Topic Newer Topic >>

Backup Database marked as "SUSPECT" by the SQ... - 18.Aug.2009 3:12:29 AM

Budz

Posts: 4
Score: 0
Joined: 14.Apr.2009
Status: offline

Hi,

We encounter a problem from our GFi Server that the said GFi Server becomes unresponsive or hang up (System unresponsive) every time we launch the report pack and generate a report. Then we will need to make a hard reset on the server.We look at the events viewer of the said server and we found that the cause of the problem (System unresponsive) is pointing our backup database from the GFi ESM, then we launch the SQL Studio and we saw the backup database (EventsManager_AugBkp) was marked as "SUSPECT" and we cant even detach the said database and we cant even see its properties. Can we still be recover the said database that is marked as "SUSPECT"? since all the Event Logs from Aug 01-05, 2009 resides on it.

Thanks and best regards,
Budz

_____________________________

Salvador M. Penganon II
CT-NOC � HTMT Manila Site

HINDUJA GLOBAL SOLUTIONS LTD.
Email: salvador.penganon@hindujagsl.com Web: www.hindujagsl.com
CANADA | INDIA | MAURITIUS | PHILIPPINES | UNITED KINGDOM | UNITED STATES |

Post #: 1

RE: Backup Database marked as "SUSPECT" by th... - 18.Aug.2009 8:44:24 AM

DrewE

Posts: 1058
Score: 0
Joined: 28.Apr.2008
From: Cary, NC
Status: offline

Can you determine what account is the DBO (Database Owner) for this database? Sometimes when a database is owned by an employee, and that employee leaves the company, or the account is disable / deleted this type of trouble can occur.

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to Budz)

Post #: 2