Error 9001 Sql Server 2000
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 Stack Overflow the company Business Learn more about hiring sql server error 9001 tempdb developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ sql server fatal error 9001 Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how microsoft sql server error 9001 it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Diagnosing Microsoft SQL Server error 9001: The log for the database is not available up vote 15 down vote fatal error 9001 occurred sql server 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 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
Warning Fatal Error 9001 Occurred Sql Server
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 next steps I should take to diagnose this problem? How can I determine if this is, indeed, a hardware problem? And if it is, are there any options beyond replacing the disk? Thanks sql-server-2008 share|improve this question asked Feb 21 '11 at 23:18 Scott Mitchell 2361310 add a comment| 6 Answers 6 active oldest votes
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008
Sqlserver 9001
» SQL Server 2008 Administration » Log not available error 9001 19 posts,Page the log for database is not available error 9001 1 of 212»» Log not available error 9001 Rate Topic Display Mode Topic Options Author Message shaun.stuartshaun.stuart Posted Monday, December error 9001 severity 21 state 1 tempdb 20, 2010 7:31 AM SSCommitted Group: General Forum Members Last Login: Friday, October 7, 2016 8:42 AM Points: 1,949, Visits: 837 Came in to work this morning to face a bunch of http://serverfault.com/questions/238394/diagnosing-microsoft-sql-server-error-9001-the-log-for-the-database-is-not-avai/238398 alerts for severity 21 errors."DESCRIPTION: The log for database 'SpotlightManagementFramework' is not available. Check the event log for related error messages. Resolve any errors and restart the database."Hmm.. The drive the log is on was available and logs for other DB were on it. Plenty of space left. Window Application event log showed no errors other than the one listed above. Windows System log http://www.sqlservercentral.com/Forums/Topic1037190-1550-1.aspx showed no errors. I ran dbcc checkdb on the database and the only error reported was that the log was not available.I took the database offline, then brought it online again and all seems good now. DBCC Checkdb gives no errors. DBCC loginfo(0) gives info, so I'm assuming the log is available. Now just trying to figure out what happened.Took a closer look at the SQL error log and I see this:12/20/2010 02:30:01,spid20s,Unknown,The log for database 'SpotlightManagementFramework' is not available. Check the event log for related error messages. Resolve any errors and restart the database.12/20/2010 02:30:01,spid20s,Unknown,Error: 9001
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=155435 forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register http://forums.asp.net/t/1529840.aspx?error+9001+tempdb+is+not+available Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) The log for database 'tempdb' is not available Reply to Topic Printer Friendly Author Topic denis_the_thief Aged Yak Warrior Canada 596 Posts Posted-01/19/2011: 13:25:06 SQL Server shut itself down yesterday. Some weird errors. error 9001 Any ideas where to start? SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.ldf] in database [tempdb] (2). The OS file handle is 0x000006C4. The offset of the latest long I/O is: 0x00000001540000...LogWriter: Operating system error 1784(error not found) encountered....The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the fatal error 9001 database.thenSQL Server must shut down in order to recover a database (database ID 2). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database. tkizer Almighty SQL Goddess USA 38200 Posts Posted-01/19/2011: 13:36:12 Sounds like you ran into a disk problem. Run hardware diagnostics to figure out what's going wrong. It should be able to restart on its own because tempdb gets recreated, but you do need to resolve the hardware issue to prevent this from happening again.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog denis_the_thief Aged Yak Warrior Canada 596 Posts Posted-01/19/2011: 13:46:03 quote:Originally posted by tkizerSounds like you ran into a disk problem. Run hardware diagnostics to figure out what's going wrong. It should be able to restart on its own because tempdb gets recreated, but you do need to resolve the hardware issue to prevent this from happening again.Tara KizerThankyou for suggesting hardware.For whatever reason it did not restart on its own although I was able to restart it easy enough. Sachin.Nand Flowing Fount of Yak Knowledge 2937 Posts Posted-01/23/2011: 09:57:30 Maybe you should set up a alert in c
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/DataSource Controls - SqlDataSource, ObjectDataSource, etc/error 9001 tempdb is not available error 9001 tempdb is not available [Answered]RSS 2 replies Last post Mar 29, 2010 03:15 AM by KumarHarsh ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply schauhan13 Member 37 Points 209 Posts error 9001 tempdb is not available Feb 25, 2010 09:47 AM|schauhan13|LINK am a vb.net programmer. I created following stored procedure on SQL Server 2000:- -- ============================================= -- Author: