Results 1 to 4 of 4

Thread: Data gets corrupted on power loss

  1. #1
    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.

  2. #2
    Join Date
    May 2008
    Posts
    2,297

    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

  3. #3
    Join Date
    Oct 2005
    Posts
    2,393

    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.

  4. #4
    Join Date
    May 2008
    Posts
    2,389

    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

Similar Threads

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

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,634,594.66271 seconds with 17 queries