What version of SQL are you running? What you may want to try is to create
a database with the same files as this one, stop SQL copy the .dat or
..mdf/.ndf/.ldf files to a working hard drive while SQL is stopped. Start
SQL, and if the database comes up suspect, try changing the status of the
master..sysdatabases table to an online status. It is a tricky thing, but
at least worth a shot before going to hard drive recovery services.
When doing backups that you don't have time to validate, my best
recommendation is to always to a disk backup, then copy it to tape. It is
very easy to corrupt a tape format, but you have more flexibility with
trying to get a disk backup to restore. Of course that is an easy cop out
on my part since that assumes there is a working hard drive with enough
space.
--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1 RemoveThis @NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a <a style='text-decoration: underline;' href="http://" target="_blank">http://</a> link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
"Lalit Kumar" <sklalit RemoveThis @yahoo.co.uk> wrote in message
news:05de01c3c46c$928f6910$a501280a@phx.gbl...
> Hi
>
> My hard disk got crashed. With the help of third party
> software i took backup of my corrupted database but now as
> i am trying to restore the database it gives me error the
> file --- is not valid microsoft tape format.
>
> Thanks
> Lalit Kumar
>
><!-- ~MESSAGE_AFTER~ -->
FAQ
Profile
Private Messages
Log in
