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 2000 Forums
 SQL Server Administration (2000)
 Cannot bring Database Online: Urgent :)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shehz
Starting Member

10 Posts

Posted - 10/04/2006 :  12:09:44  Show Profile  Reply with Quote
Hello we had some power surges and unfornately one of our cliens database got corrupted and went to suspect\offline mode automatically. I tried to bring online and it gives me this Error

"Error 823:I\O error(bad page ID) detected during read of BUF pointer=0X11c10400,page ptr=0X1f920000,pageid=(0X1:0x2),............ 416 transanctions rolled forward in database 'xxxx'(20)"

Unfortunately the last backup made was on 2004..Is there anyway to fix this database? any disaster recovery or where you pay to get this db fixed. The rest of the databases are working fine. Also I'm using an old Sql server 7. Any settings I have to reset /refresh on sql server 7? please guide me..

Thanks

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 10/04/2006 :  12:25:11  Show Profile  Visit nr's Homepage  Reply with Quote
see
http://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.html

Take a backup of thedata files first.
You can send them away for data recovery - a few companies including microsoft will do thuis.

>> Unfortunately the last backup made was on 2004
They get very little sympathy for that.

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

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/04/2006 :  14:46:35  Show Profile  Reply with Quote
"The rest of the databases are working fine"

if you haven't done so already I recommend run:

DBCC CHECKDB('database_name') WITH NO_INFOMSGS

on each one to make sure that there are no corruptions.

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36946 Posts

Posted - 10/04/2006 :  14:50:24  Show Profile  Visit tkizer's Homepage  Reply with Quote
Someone should lose their job over this. Not having a backup in 2 years is unacceptable. Imagine the look on the faces of upper management when they hear that part.

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/04/2006 :  14:59:10  Show Profile  Reply with Quote
Might have been a typo ... might have been 20:04 yesterday?
Go to Top of Page

shehz
Starting Member

10 Posts

Posted - 10/05/2006 :  15:39:21  Show Profile  Reply with Quote
Thanks for the suggestion guys. I agree it is pathetic not to have a backup. I"m actually cleaning up my former developers mess.
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