disaster recovery

my server has 3 partitions (c: , d: ,e:). my sql 2000 is
in d: and my win 2K is in c:. my c drive crashed and i
would like to recover my sql database in d: after i
reinstall my win 2K in c:. is that possible?Hi Bobby.
If SQL Server managed to shot down successfully, it would have checkpointed
the databases & you might be able to re-attach the .mdb files after
re-installing Windows / SQL Server. To attach a db, you can either use the
sp_attach_db stored proc or the SQL Enterprise Manager has a menu option to
do it - right click on the "databases" node, select "All Tasks" then "Attach
Database" & follow the prompts..
Do you have a backup of the database? If so, this is likely the better
option if the system crashed before you lost it.
Regards,
Greg Linwood
SQL Server MVP
"bobby" <bllua@.hotmail.com> wrote in message
news:09e601c37f3f$3ea1bc80$a401280a@.phx.gbl...
> my server has 3 partitions (c: , d: ,e:). my sql 2000 is
> in d: and my win 2K is in c:. my c drive crashed and i
> would like to recover my sql database in d: after i
> reinstall my win 2K in c:. is that possible?|||"Greg Linwood" <g_linwood@.hotmail.com> wrote in message
news:eQepu%230fDHA.944@.TK2MSFTNGP11.phx.gbl...
> Hi Bobby.
> If SQL Server managed to shot down successfully, it would have
checkpointed
> the databases & you might be able to re-attach the .mdb files after
> re-installing Windows / SQL Server. To attach a db, you can either use the
> sp_attach_db stored proc or the SQL Enterprise Manager has a menu option
to
> do it - right click on the "databases" node, select "All Tasks" then
"Attach
> Database" & follow the prompts..
> Do you have a backup of the database? If so, this is likely the better
> option if the system crashed before you lost it.
> Regards,
> Greg Linwood
> SQL Server MVP
Also, if you have a backup of your Master database you would not have to
re-attach the db files
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.520 / Virus Database: 318 - Release Date: 18/09/2003