repair corrupt database?

Hi,
How can I repair a corrupt database? The situation is that I
have the first 2.8gig of a 3.3gb database, the rest couldn't be read
because of a faulty hard drive.
I have the actual backup, and the .mdf file, but both would hold
the same amount of data.
Any help please?
ThanksAssuming the db is suspect and you are indeed performing regular log backups:
Do a log backup using the NO_TRUNCATE option, then restore the latest clean db backup and all
subsequent log backups.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"jekZ" <jekz@.nospam.com> wrote in message news:NxmdnV8LEsanSeeiU-KYuQ@.is.co.za...
> Hi,
> How can I repair a corrupt database? The situation is that I
> have the first 2.8gig of a 3.3gb database, the rest couldn't be read
> because of a faulty hard drive.
> I have the actual backup, and the .mdf file, but both would hold
> the same amount of data.
> Any help please?
> Thanks
>