Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

cyclic redunceyerror Expand / Collapse
Author
Message
Posted Monday, July 14, 2008 12:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Tuesday, July 15, 2008 7:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 28, 2014 12:56 AM
Points: 115, Visits: 317
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
Posted Tuesday, July 15, 2008 11:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Wednesday, July 16, 2008 4:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 7, 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
Posted Thursday, July 17, 2008 8:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 28, 2014 12:56 AM
Points: 115, Visits: 317
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
Posted Saturday, July 19, 2008 7:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, July 21, 2008 3:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 28, 2014 12:56 AM
Points: 115, Visits: 317
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 »

Add to briefcase

Permissions Expand / Collapse