Retrieving a saved MSSQL database after re-formatting the original hard drive

I had to re-format my hard drive because of a crash. How
could I retrieve the database which I had backed-up on
another hard drive before the crash?After you reload SQL Server you can use the RESTORE command to get it back.
Check out RESTORE in BooksOnLine.
--
Andrew J. Kelly
SQL Server MVP
"L. Dettering" <anonymous@.discussions.microsoft.com> wrote in message
news:1581601c4470e$c2f95190$a601280a@.phx.gbl...
> I had to re-format my hard drive because of a crash. How
> could I retrieve the database which I had backed-up on
> another hard drive before the crash?|||Hi,
To add on to Andrew and Tiber (other post).
1. Install SQL server and Service packs same as old
2. Restore master database first
Have a look into steps (15 - 28) in the attached link.
http://www.dbarecovery.com/restoremasterdb.html
3. restore MSDB database using RESTORE command
4. Finally restore the user databases again with RESTORE command.
Refer books online for RESTORE syntax / usage.
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OhXfhGxREHA.2936@.TK2MSFTNGP12.phx.gbl...
> After you reload SQL Server you can use the RESTORE command to get it
back.
> Check out RESTORE in BooksOnLine.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "L. Dettering" <anonymous@.discussions.microsoft.com> wrote in message
> news:1581601c4470e$c2f95190$a601280a@.phx.gbl...
> > I had to re-format my hard drive because of a crash. How
> > could I retrieve the database which I had backed-up on
> > another hard drive before the crash?
>