Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: Sql Data Recovery

    Hi,

    i am using sql server 2000. yesterday my server shows blue screen after that when i start again it was showing messges like registry or system files corrupted....
    after that i remove HDD from server and put it on another machine to copy databse files(.mdf and .ldf) but i found that mdf file size has changed from 1.6 GB to 2048 KB and
    LDF file showing 1.6 GB from 2048 KB. after that i was trying to copy both files into new location, but only able to copy MDF file(corrupted). while copying ldf file i am getting message like
    I/O error. i don't have latest backup.
    so i want to know after recovering ldf file from HDD can i would be able to get back my original database. pls help.
    Thanks

  2. #2
    Join Date
    May 2009
    Posts
    1

    Smile Re: Sql Data Recovery

    Hi Sunil,

    Such problems occur due to bad sectors in your hard drives.
    To overcome this problem do one thing, just changed ldf file as mdf and mdf file as ldf.

  3. #3
    Join Date
    Mar 2009
    Posts
    349
    what? change the file extensions? are you mad?

    do not do that.

    Have you been taking backups?

    I get it. THIS IS SPAM.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Taken care of....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2009
    Posts
    2

    it's work

    Quote Originally Posted by Davidpoul
    Hi Sunil,

    Such problems occur due to bad sectors in your hard drives.
    To overcome this problem do one thing, just changed ldf file as mdf and mdf file as ldf.

    hi paul,

    thanks for reply,
    yes....i tried the same and it's work. but still i am not able to digest that.


    thanks
    sunil

  6. #6
    Join Date
    Mar 2009
    Posts
    349
    bamma please. The hyperlink in dudes sginature just happened to match the thread title.

    Are you really saying this is a legitimate thread and that changing the file extensions did anything but screw up your database? That's frigging hilarious.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •