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?
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
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.
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