Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 14-11-2009
Member
 
Join Date: Jan 2009
Posts: 23
Data gets corrupted on power loss

Hi,

I am I.T student and I am too much frustrated because of data corruption problem.
The applicationon my PC is opens the connection to SQlExpress when I start and close the connection.
But When the appl is running, and if some power failure happens, my database gets corrupted. When I try to open next time it's showing a error message saying "the database wasn't properly shutdown".

Is there any way to avoid this data corruption or any solution to recover corrupted databse?

Last edited by Jaishree : 14-11-2009 at 11:09 AM.
Reply With Quote
  #2  
Old 14-11-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Data gets corrupted on power loss

Firstly I would like to recommend you that to make Power backup. According to me this problem occurred because of abrupt system shut down SQL database mostly gets corrupted.

You can try one of solution mentioned below:

i).You can recover stored data from corrupted database through backup

ii).You can use SQL db recovery and repair s/w
Reply With Quote
  #3  
Old 14-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Data gets corrupted on power loss

It is very rare that sql database file gets corrupted because of abrupt shutdowns.
This problem might happen if drive is using non-battery backed cache memory and few data been written not makes it to disk.

Please use database recovery software, definitely this will works for you.
Reply With Quote
  #4  
Old 14-11-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: Data gets corrupted on power loss

if you didn't make backup ,you try DBCC CHECKDB to get repair your database.After the use of DBCC CHECKDB please open your db

If you can't open your db this means your db get damaged and you will have to get repaired it by using sql recovery tool.

You can find this tool at below address:

http://www.repair-mssql-database.com...r-software.php
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Data gets corrupted on power loss"
Thread Thread Starter Forum Replies Last Post
Lenovo ThinkPad T61 randomly loss of power Lyudmyla Portable Devices 5 29-07-2011 10:17 AM
Need Help To avoid data loss while on net Roger Zelazny Networking & Security 5 01-03-2011 10:18 PM
What are causes of data loss? Frieda Operating Systems 5 18-02-2011 02:53 PM
What to do when Data Loss happens? sivaranjan Windows Software 6 01-04-2010 09:23 AM
Data Loss on RAID Ravi Singh Operating Systems 3 28-08-2009 11:47 PM


All times are GMT +5.5. The time now is 06:45 AM.