July 14, 2008 at 12:53 am
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.........?
July 15, 2008 at 7:44 am
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
July 15, 2008 at 11:20 pm
database corrupted and it shows the error CRC
How it can solved..........Any solution..?
July 16, 2008 at 4:47 am
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...;)
July 17, 2008 at 8:31 am
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
July 19, 2008 at 7:35 am
s...
when i copied mdf file it shows because of database suspect
thanks a lot
July 21, 2008 at 3:08 pm
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply