| HDD GURU FORUMS http://forum.hddguru.com/ |
|
| SQL DATABASE need to recover - cmd line http://forum.hddguru.com/viewtopic.php?f=7&t=12384 |
Page 1 of 1 |
| Author: | zebong [ May 30th, 2009, 20:03 ] |
| Post subject: | SQL DATABASE need to recover - cmd line |
Hi to all, I have copy a disk with some SQL databases and could copy about 98% off the sectors for the database. But is missing 2% off that sectors, anyone experience in SQL server know the command line to repair the database? Please PM me Thanks ZeBong |
|
| Author: | N.C. [ May 31st, 2009, 7:07 ] |
| Post subject: | Re: SQL DATABASE need to recover - cmd line |
Hi, It depends on sql type, but for mysql the procedure looks like this: USE [database] REPAIR TABLE [table] If it is failing, try outside of the server with myisamchk. http://dev.mysql.com/doc/refman/5.0/en/ ... table.html Always make a backup before trying to repair the table! Janos |
|
| Page 1 of 1 | All times are UTC - 5 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|