You're gonna have to do a restore from the previous nights backup on the new
Disk drive set and hope for the best with the transaction logs.
The below is taken from BOL, and has lots of information about backing up
and restoring databases...
How to restore to the point of failure (Transact-SQL)
To restore to the point of failure
1. Execute the BACKUP LOG statement using the NO_TRUNCATE clause to back up
the currently active transaction log.
2. Execute the RESTORE DATABASE statement using the NORECOVERY clause to
restore the database backup.
3. Execute the RESTORE LOG statement using the NORECOVERY clause to apply
each transaction log backup.
4. Execute the RESTORE LOG statement using the RECOVERY clause to apply the
transaction log backup created in Step 1.

-----Original Message-----
From: Yukon DBA [mailto:[Email Address Removed]
Sent: Wednesday, September 18, 2002 7:34 AM
To: LazyDBA.com Discussion
Subject: Tail Backup

Hi All,
Small correction on my previous query,
Data file HDD is crashed,
Log file HDD is Good.,

Please give your valuable suggestions
----- Original Message -----
From: Yukon DBA
To: [Email Address Removed] ; [Email Address Removed]
Sent: Wednesday, September 18, 2002 6:49 PM
Subject: Tail Backup


Hi,
The scenario is like this,

Log file HDD is crashed,
Data file HDD is good,
Now Database is in Suspect mode.

How to take the tail log backup for getting the last min records?

Have anybody faced the problem like this,

Thanks in Advance,
KM
MS Sql Server LazyDBA home page