Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MS SQL SERVER Event ID 9001

Posted on 2012-08-30
2
Medium Priority
?
1,591 Views
Last Modified: 2012-10-16
Dear All,
                The database server is windows server 2003 64 bit, instaled with MS sql server 2008 R2 64 bit.

all of sudden i started to recieve the Event id 9001 in the event viewer.

we checked the HDD of the server and they are ok, we run chkdsk but we still getting the error (please check the attached screenshot event id 9001).

and on the sql server,when we extract the SQL replication, local publications the SQL hangs and another error is logged on event viewer , Event Id 823 ( check attached)

Kindly advice af all of these are related or not, and what should be done to solve these issues
Event-Id-9001-.JPG
Event-ID-823.jpg
SQL-Error.jpg
0
Comment
Question by:mostabdo
2 Comments
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 1000 total points
ID: 38350955
On the face of things you appear to have lost access to the transaction log file (9001) of one of your databases! You should make an immediate backup of everything on the disk(s) involved and start looking for problems (823).

( ref   here )
0
 
LVL 9

Accepted Solution

by:
Vijaya Reddy Pinnapa Reddy earned 1000 total points
ID: 38350988
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Integration Management Part 2
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

804 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question