Data File Crash

[manohars]

Data files and log files are kept in separate disks of my database. If the disk which contains data files crashes, is it possible to take the log backup and then recover the database to the point of failure.

Thanks in Advance,
Manohar

 

[JayKusch]

Yes it is. You would also need your last full incremental, or if you are doing Differentials, you would need your last full + the diffs + the tlogs to recover.

Thanks

J. Kusch

 

[manohars]

I just want to make sure of this one. Is it possible to take log backup at that time, when data files are crashed. Because, database may not be accessible.

Thanks,
Manohar