Event Id 17052 Error 9001
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about the log for database tempdb is not available error 9001 Stack Overflow the company Business Learn more about hiring developers or posting ads with
Fatal Error 9001 Occurred Sql Server
us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system the log for database is not available. check the event log for related error messages and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Diagnosing
The Log For Database Is Not Available Sql Server
Microsoft SQL Server error 9001: The log for the database is not available up vote 15 down vote favorite 2 Over the weekend a website I run stopped functioning, recording the following error in the Event Viewer each time a request is made to the website: Event ID: 9001 The log for database 'database name' is not available. Check the event log for related error messages. Resolve any errors and restart system.data.sqlclient.sqlexception: warning: fatal error 9001 the database. The website is hosted on a dedicated server, so I am able to RDP into the server and poke around. The LDF file for the database exists in the C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA folder, but attempting to do any work with the database from Management Studio results in a dialog box reporting the same error - 9001: The log for database is not available... This is the first time I've received this error, and I've been hosting this site (and others) on this dedicated web server for over two years now. It is my understanding that this error indicates a corrupt log file. I was able to get the website back online by Detaching the database and then restoring a backup from a couple days ago, but my concern is that this error is indicative of a more sinister problem, namely a hard drive failure. I emailed support at the web hosting company and this was their reply: There doesn't appear to be any other indications of the cause in the Event Log, so it's possible that the log was corrupted. Currently the memory's resources is at 87%, which also may have an impact but is unlikely. Can the log just "become corrupted?" My question: What are the
additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL%20Server&ProdVer=2000.80.760.0&EvtID=9001&EvtSrc=MSSQLServer&LCID=1033 areas for which we need to provide more information. If the product or version you are looking for is not listed, you can use this search box to search TechNet, the Microsoft Knowledge Base, and TechNet Blogs for more information. Enter the product name, event source, and event ID. For example: Vista Application Error 1001.
by Oliver[M » Tue, 30 Jul 2002 12:20:14 You http://www.verycomputer.com/156_31b140554b612132_1.htm can help to check whether the sql server startup account has the permission to access that log folder and files. Regards, Oliver [MS] This posting is provided "AS IS" with no warranties, and confers no rights. Get Secure! - www.microsoft.com/security Top 1. Event 17052 MSSQLServer Error: error 9001 0, Severity: 19, State: 0 Can anyone help with this application log event, which appears several times eventually crashing the system It's a Win 2000 Adv Srv SP2 server running SQL 2000 SP2 Server: SQLServer1 Source: MSSQLSERVER Category: Server Event ID: 17052 Time: Thu Jul 25 11:25:40 2002 Error: the log for 0, Severity: 19, State: 0 language_exec: Process 59 generated an access violation. SQL Server is terminating this process. The process specified does vary, however the event details and Error: 0, Severity: 19, State: 0 stays constant. Thanks Harry 2. ADODB.Command, passed through process bounds, wouldn't accept Connection 3. Error: 3314, Severity: 21, State: 2 / Error while undoing logged operation in database 4. Memory for VB5.0 ???? 5. Event ID 17055-18052 :Error: 9001, Severity: 21, State: 1.?? 6. Querying several tables within a database dynamically. 7. Error : 1608, Severity: 21, State: 2 8. XML encoding switch 9. Error: 1109, Severity 21, State: 1 10. Help: sql 6.5 : Error : 605, Severity: 21, State: 1 11. *urgent* Error 602, Severity 21, State 8 12. Error : 1608, Severity: 21, State: 2 1 post • Page:1 of 1 All times are UTC Board index Spam Report