Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.Install SQL Server again. Then use the RESTORE DATABASE command to restore y
our database backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a40128
0a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>|||Install SQL Server again. Then use the RESTORE DATABASE command to
restore your
database backups.
I did that. Choosing Database, in Parameters, there's no 'First backup
to restore' shown and I'm required to select a backup to restore.
Choosing Filegroups of files instead of Database, I 'Select a subset of
backup sets' and for Selection Criteria, I select 'Only the backup sets
of the data files on drive F, and get this message: 'The current filter
excludes all existing backup sets. Change the filter to include at least
one backup set,' Checking, additionally, 'Only the backup sets completed
after 04/28/2004' (the last backup was on 04/29/2004), I get the same
message. Selecting 'Only backup sets of the following filegroups and
files', I can't enter the names of the filegroups and/or files.
If I select the F: drive where the files are saved in F:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\Data\DataFiles_Data.MDF, I'm
informed that it's not a valid Microsoft Tape Format backup set.
'RESTORE DATABASE is terminating abnormally'. '?
Could you help? I'm new at this!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!