cyclic redunceyerror

  • devarajan.mca

    Valued Member

    Points: 64

    hi every one

    any body help me ..

    when i copied a mdf file it shows error

    cyclic redunacy Error occured

    may i know what is the problem and how can i solve this..?

    help me regarding this.........?

  • Doug S.

    SSCrazy

    Points: 2801

    CRC errors are data corruption errors. Look it up on wikipedia.

    There must have been a CRC checksum and you have been warned that your data is bad. Try to copy the file again.

    Good luck


    Doug

  • devarajan.mca

    Valued Member

    Points: 64

    database corrupted and it shows the error CRC

    How it can solved..........Any solution..?

  • Nagesh Nayak

    Grasshopper

    Points: 22

    Are you getting the CRC error while attaching the MDF to SQL instance?? If the mdf is corrupted because of disk issues then my friend i would recommend to switch to backup copy of this database.

    There are methods to attach a corrupt data file to SQL instance but you would end up doing repair with data loss option which may put database in worst situation. Like i said go back to backup if you have it...;)

  • Doug S.

    SSCrazy

    Points: 2801

    I think it depends on how they used the CRC. Is it on a table, a table row, or ???? If anybody knows the answer please post.

    First determine if (a) original file is bad, if so go to backup. next, if copy is bad, then try again. I've had bad copies using FTP sometimes. Zipping and using FTP will sometimes solve the problem.

    Good luck


    Doug

  • devarajan.mca

    Valued Member

    Points: 64

    s...

    when i copied mdf file it shows because of database suspect

    thanks a lot

  • Doug S.

    SSCrazy

    Points: 2801

    To find out more about CRCs and corrupted databases this is a good place to start

    http://www.sqlskills.com/blogs/paul/default,month,2008-07.aspx

    Best of luck

    D


    Doug

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply