Hi,
I have SQL Server 2005 database which has very important data. For protection of data I am following Full Recovery model So that I can take the tail log backup to point of database failure.
Now I want to know that, If sql server gets crashed or Hard disk which contains .mdf and .ldf life that it self gets crashed then how will I recover data.
In short I want to know that, in real time scenario how to recover data from server crash or hard disk crash? How should be disaster recovery plan ?
Any suggestion will be appreciated.........
Thanks & Regards
Vinod.km