View topic - SQL DATABASE need to recover

Main » Forums home » Software and hardware tools

All times are UTC - 5 hours [ DST ]

SQL DATABASE need to recover - cmd line

Page 1 of 1

[ 2 posts ]

Print view

Previous topic | Next topic

Author

Message

zebong

Post subject: SQL DATABASE need to recover - cmd line

Posted: May 30th, 2009, 20:03

Joined: December 24th, 2007, 16:08
Posts: 1422
Location: EUROPE

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

_________________
ZeBong
" что случилось в России - останется в России "
" Россия еще раз"

Top

N.C.

Post subject: Re: SQL DATABASE need to recover - cmd line

Posted: May 31st, 2009, 7:07

Joined: March 28th, 2008, 7:52
Posts: 1479
Location: Europe, Hungary

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

Top

Page 1 of 1

[ 2 posts ]

Main » Forums home » Software and hardware tools

All times are UTC - 5 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 11 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum