cyclic redunceyerror

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by James DiMauro » cyclic redunceyerror

cyclic redunceyerror

Rate Topic

Display Mode

Topic Options

Author

Message

devarajan.mca

Posted Monday, July 14, 2008 12:53 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, February 18, 2013 8:58 PM
Points: 42, Visits: 27

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

Post #533288

Doug S.

Posted Tuesday, July 15, 2008 7:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 21, 2011 8:43 AM
Points: 115, Visits: 315

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

Post #534389

devarajan.mca

Posted Tuesday, July 15, 2008 11:20 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, February 18, 2013 8:58 PM
Points: 42, Visits: 27

database corrupted and it shows the error CRC

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

Post #534882

Nagesh Nayak

Posted Wednesday, July 16, 2008 4:47 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 07, 2011 10:18 PM
Points: 16, Visits: 12

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...;)

Post #535077

Doug S.

Posted Thursday, July 17, 2008 8:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 21, 2011 8:43 AM
Points: 115, Visits: 315

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

Post #536047

devarajan.mca

Posted Saturday, July 19, 2008 7:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, February 18, 2013 8:58 PM
Points: 42, Visits: 27

s...

when i copied mdf file it shows because of database suspect

thanks a lot

Post #537153

Doug S.

Posted Monday, July 21, 2008 3:08 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 21, 2011 8:43 AM
Points: 115, Visits: 315

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

Post #538011

« Prev Topic | Next Topic »

Permissions