MS SQL Server - Lost a drive on the SQL Server

Author

Lost a drive on the SQL Server

Meenal Dhody

2006-03-27, 9:23 am

We lost a drive on the SQL sever box. It is the drive that has all the data
files.
I wanted to detach the databases to copy them to a different drive and
attach them again to lose minimal work.
However it will not give my that option. Now SQL Server will not even
shutdown properly.
Is there anything I can do other than restore the backup from last night?
We are running SQL server 2000 sp3a.

Any help is appreciated.

thanks
Meenal

Quentin Ran

2006-03-27, 1:23 pm

A few things you can try:

1. if it is a raid and you have lost one drive, you should be able to
replace the bad drive without much, if any, residual effect.
2. if you indeed have just that one drive or your raid does not have
redundancy, your best luck is probably retrieve whatever is still
retrievable and try to reattach the DBs they represent to the server
3. if the drive does not work at all, you may want stick it to a linux
machine and see whether you can recover it from there

Good luck

Quentin

"Meenal Dhody" < meenal_dhody@hotmail
.com> wrote in message
news:e3uBWmaUGHA.4956@TK2MSFTNGP09.phx.gbl...
> We lost a drive on the SQL sever box. It is the drive that has all the
> data
> files.
> I wanted to detach the databases to copy them to a different drive and
> attach them again to lose minimal work.
> However it will not give my that option. Now SQL Server will not even
> shutdown properly.
> Is there anything I can do other than restore the backup from last night?
> We are running SQL server 2000 sp3a.
>
> Any help is appreciated.
>
> thanks
> Meenal
>
>

Ben Nevarez

2006-03-27, 1:23 pm

Hi,

Perhaps we need more information about the current status of the instance.
Is it working properly? If not, can you start it?

What I would do is:

1) You lost the data files? Do you have the transaction logs?
2) Can you get the tail of the log? (Check BACKUP LOG command and the WITH
NO_TRUNCATE option)
3) In theory, if you have the required backups and the tail of the log you
can recover your database to the point of failure

Ben Nevarez, MCDBA, OCP
Database Administrator

"Meenal Dhody" wrote:

> We lost a drive on the SQL sever box. It is the drive that has all the data
> files.
> I wanted to detach the databases to copy them to a different drive and
> attach them again to lose minimal work.
> However it will not give my that option. Now SQL Server will not even
> shutdown properly.
> Is there anything I can do other than restore the backup from last night?
> We are running SQL server 2000 sp3a.
>
> Any help is appreciated.
>
> thanks
> Meenal
>
>
>

Sponsored Links