corrupted backup file

We run SQL backup jobs everyday to backup the DB. Our server crashed,
so we're trying to restore the database using the backup file (*.bak)
However, we noticed that we're unable to restore the DB because the
backup file is corrupted. Does anyone have any suggestion how we can
restore the DB? I'm not sure if our MDF & LDF files are good. If MDF &
LDF are also corrupted, how do we restore our DB using the corrupted
backup file? Help!Try attaching the mdf, ndf, ldf files using sp_attach_db or even sp_attach_s
ingle_file_db. Read
about the commands in Books Online. If that doesn't work and your backup fil
es are corrupt, you are
probably toast. Open a case with MS Support and see if they can assist in an
y way. Or revert to the
oldest OK backup files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yvonne" <y999yy@.yahoo.com> wrote in message news:cc95dfb3.0406302236.57ab05be@.posting.googl
e.com...
> We run SQL backup jobs everyday to backup the DB. Our server crashed,
> so we're trying to restore the database using the backup file (*.bak)
> However, we noticed that we're unable to restore the DB because the
> backup file is corrupted. Does anyone have any suggestion how we can
> restore the DB? I'm not sure if our MDF & LDF files are good. If MDF &
> LDF are also corrupted, how do we restore our DB using the corrupted
> backup file? Help!|||Tried both sp_attach_db & sp_attach_single_file_db, but failed. Seems
some problem with the log file that the DB is unable to be recreated.
One question, the DB was originally installed on SQL 2000 Personal
version. Was trying to attach to SQL 2000 Enterprise version. Does
that make any differece? Should we try to attach the DB to a personal
version?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<ef
oIZgzXEHA.716@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Try attaching the mdf, ndf, ldf files using sp_attach_db or even sp_attach
_single_file_db. Read
> about the commands in Books Online. If that doesn't work and your backup f
iles are corrupt, you are
> probably toast. Open a case with MS Support and see if they can assist in
any way. Or revert to the
> oldest OK backup files.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yvonne" <y999yy@.yahoo.com> wrote in message news:cc95dfb3.0406302236.57ab
05be@.posting.google.com...|||Tried both sp_attach_db & sp_attach_single_file_db, but failed. Seems
some problem with the log file that the DB is unable to be recreated.
One question, the DB was originally installed on SQL 2000 Personal
version. Was trying to attach to SQL 2000 Enterprise version. Does
that make any differece? Should we try to attach the DB to a personal
version?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<ef
oIZgzXEHA.716@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Try attaching the mdf, ndf, ldf files using sp_attach_db or even sp_attach
_single_file_db. Read
> about the commands in Books Online. If that doesn't work and your backup f
iles are corrupt, you are
> probably toast. Open a case with MS Support and see if they can assist in
any way. Or revert to the
> oldest OK backup files.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yvonne" <y999yy@.yahoo.com> wrote in message news:cc95dfb3.0406302236.57ab
05be@.posting.google.com...|||Tried both sp_attach_db & sp_attach_single_file_db, but failed. The
error is always on the ldf file. Isn't the DB able to recreate the log
file from mdf?
Since the origianl dB was installed on SQL 2000 personal version. Was
trying to restore to a SQL 2000 enterprise version. Does this also
make any difference?
Since our disk was corrupted, so I was afraid that the corrupted mdf
was on some bad sector of the disk. Any suggestion?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<ef
oIZgzXEHA.716@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Try attaching the mdf, ndf, ldf files using sp_attach_db or even sp_attach
_single_file_db. Read
> about the commands in Books Online. If that doesn't work and your backup f
iles are corrupt, you are
> probably toast. Open a case with MS Support and see if they can assist in
any way. Or revert to the
> oldest OK backup files.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yvonne" <y999yy@.yahoo.com> wrote in message news:cc95dfb3.0406302236.57ab
05be@.posting.google.com...|||Tried both sp_attach_db & sp_attach_single_file_db, but failed. The
error is always on the ldf file. Isn't the DB able to recreate the log
file from mdf?
Since the origianl dB was installed on SQL 2000 personal version. Was
trying to restore to a SQL 2000 enterprise version. Does this also
make any difference?
Since our disk was corrupted, so I was afraid that the corrupted mdf
was on some bad sector of the disk. Any suggestion?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<ef
oIZgzXEHA.716@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Try attaching the mdf, ndf, ldf files using sp_attach_db or even sp_attach
_single_file_db. Read
> about the commands in Books Online. If that doesn't work and your backup f
iles are corrupt, you are
> probably toast. Open a case with MS Support and see if they can assist in
any way. Or revert to the
> oldest OK backup files.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yvonne" <y999yy@.yahoo.com> wrote in message news:cc95dfb3.0406302236.57ab
05be@.posting.google.com...|||> Isn't the DB able to recreate the log
> file from mdf?
No. I suggest you read in Books Online about "automatic recovery" and you un
derstand why. If there
is not automatic recovery work to be done, and SQL Server know that, SQL Ser
ver can re-create a
transaction log file for you.

> Since the origianl dB was installed on SQL 2000 personal version. Was
> trying to restore to a SQL 2000 enterprise version. Does this also
> make any difference?
No. File format is the same over all editions.

> Since our disk was corrupted, so I was afraid that the corrupted mdf
> was on some bad sector of the disk. Any suggestion?
As I mentioned. Restore your latest clean backup or open a case with MS and
see if they can help
you.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yvonne" <y999yy@.yahoo.com> wrote in message news:cc95dfb3.0407012212.212307e8@.posting.googl
e.com...
> Tried both sp_attach_db & sp_attach_single_file_db, but failed. The
> error is always on the ldf file. Isn't the DB able to recreate the log
> file from mdf?
> Since the origianl dB was installed on SQL 2000 personal version. Was
> trying to restore to a SQL 2000 enterprise version. Does this also
> make any difference?
> Since our disk was corrupted, so I was afraid that the corrupted mdf
> was on some bad sector of the disk. Any suggestion?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in messag
e
news:<efoIZgzXEHA.716@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
are[vbcol=seagreen]
the[vbcol=seagreen]
news:cc95dfb3.0406302236.57ab05be@.posting.google.com...[vbcol=seagreen]