November 20, 2009 at 5:28 pm
Hi,
I have read about the various forms of SQL Server HA strategies, but I am confused. My questions are:
-What benefit does a transaction log backup have over a database backup?
-Database mirroring and a failover cluster seem to be the same. In both strategies, you pretty much revert to the standby database if the main production database fails. I say database, but does this go for instance level too?
-What scenarios are useful for replication? One I read is to have a database tuned for reads and an identical one for writes. Is there anything else?
Thanks
November 20, 2009 at 6:18 pm
Please find the Article I published, it covers almost everything you asked.
Comparing the High Availability Features in SQL Server 2005
What benefit does a transaction log backup have over a database backup?
The benefit a Transaction Log backup provides is it enables you to recover data to a point in time.
Simple example:
A table named TestTable has 100 records in Database at 10 AM, and beginning from 10 AM you delete 1 records every 1 minute.
At 11 AM there will be 40 records in that table, a Full database backup will backup the table data at that point ( 40 records). So any time you use 11 AM backup, you will get that 40 records backup.
Where as if you perform a Transaction log backup of the same database at regular intervals during the same time. And you recognize that a record deleted at 10:40 AM was wrongly done and it is very important data that needs to be brought back. Your solution would be using the transaction log backup and recover till that point of time 10:39
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply