SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sal 1/0 error recovery error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kunwar.naresh
Starting Member

1 Posts

Posted - 07/19/2012 :  11:44:23  Show Profile  Reply with Quote
Please suggest some for below said prob.


Warning: You must recover this database prior to access.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 5028, Level 16, State 4, Line 1
The system could not activate enough of the database to rebuild the log.
DBCC results for 'FY20102012'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'FY20102012'.
Msg 926, Level 14, State 1, Line 1
Database 'FY20102012' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 926, Level 14, State 1, Line 1
Database 'FY20102012' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 926, Level 14, State 1, Line 1
Database 'FY20102012' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 3:31185152; actual 63104:235288040). It occurred during a read of page (3:31185152) in database ID 7 at offset 0x00003b7b200000 in file 'G:\MSSQL10.MSSQLSERVER\MSSQL\DATA\Lilliput Kidswear India HO_1.ndf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database 'FY20102012' (database ID 7) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 07/19/2012 :  12:04:10  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
You have a storage error. A page isn't where the database engine expects it to be.
Seems like a time to put your backup/recovery plan into action.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

prett
Posting Yak Master

USA
192 Posts

Posted - 07/23/2012 :  02:45:10  Show Profile  Visit prett's Homepage  Reply with Quote
If you have good backup copy then restore your database from backup otherwise use emergency mode repair to fix up this issue. Check this post: http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/18/636105.aspx

If it does not work then there is only way to fix up the database is to use SQL repair software: http://lmgtfy.com/?q=sql+repair+software
Go to Top of Page

lincoln
Starting Member

1 Posts

Posted - 04/14/2014 :  05:45:32  Show Profile  Reply with Quote
The T-SQL script command DBCC CHECKDB job is identify the level of consistency related to pages, index and tables of the SQL database during his checks if he finds some kind of error the command immediately reports an error. You can try SQL database recovery software from here :- unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000