MS SQL Server - How to Recover from: OS on drive C, SQL Server installation & mdf's on X, ldf's on Y

Author

How to Recover from: OS on drive C, SQL Server installation & mdf's on X, ldf's on Y

ebeiler@fandr.com

2006-03-05, 8:24 pm

Our main sql server has failed, and our failover procedure has failed
as well (the backup server couldn't handle the temporary strain).

Our OS was installed on one drive (drive C)

Our SQL Server installation is on drive X, along with the MDF files for
the databases.

The LDF files are on drive Y.

Drive C is fried, drive X & Y are fine. We are recreating drive C's OS
installation, but how do we handle the actual server installation being
on drive X? Do we need to run the SQL Server installation over again?
If so, are there special considerations in this case?

David Browne

2006-03-05, 8:24 pm

<ebeiler@fandr.com> wrote in message
news:1141394015.039948.245470@j33g2000cwa.googlegroups.com...
> Our main sql server has failed, and our failover procedure has failed
> as well (the backup server couldn't handle the temporary strain).
>
> Our OS was installed on one drive (drive C)
>
> Our SQL Server installation is on drive X, along with the MDF files for
> the databases.
>
> The LDF files are on drive Y.
>
>
> Drive C is fried, drive X & Y are fine. We are recreating drive C's OS
> installation, but how do we handle the actual server installation being
> on drive X? Do we need to run the SQL Server installation over again?
> If so, are there special considerations in this case?
>

You can install SQL Server normally. The program files will go on the new
drive C.

Then simply attach (or restore) your databases on drive X.

sp_attach_db
http://msdn.microsoft.com/library/d..._ae-az_52oy.asp

How to move databases between computers that are running SQL Server
http://www.support.microsoft.com/?id=314546

David

ebeiler@fandr.com

2006-03-05, 8:24 pm

Thanks for your help.

Sponsored Links