high availability | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

high availability

Someone has deleted my production DB at 5pm. (lets say..).
I need to recover everything till 4.59pm…
what are my options…I think RAID will not help because it is for HD failure….. I think, therefore I am
Restore the last backup and apply the transaction log backups on top of the same. You’ll be able to restore the database onl;y to the point where last transaction log backup was taken. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
you would need the last FULL backup done before 4.59. If there are DIFF backups 4.59 restore the last done after FULL backup and before 4.59. Restore TLOG backups until your point in time.
I know these options. What i am trying to say is HIGH AVAILABILITY. Suppose i have yesterdays full backup. And todays 2 pm log backup. But my db has been crashed at 5.00 pm.
I know i can restore my db as of 2pm. But i will not be able to restore the transactions made in 2-5pm. Suppose mine is a BANKING databse, where even a single transaction is very important. How to make sure that i will not lose even a single transaction in the above scenario..
I think, therefore I am
Refer to this MS articlehttp://www.microsoft.com/sql/techinfo/administration/2000/availability.asp about high availability and follow the suggestions. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Refer to this MS articlehttp://www.microsoft.com/sql/techinfo/administration/2000/availability.asp about high availability and follow the suggestions. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>