Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kannanchery
Starting Member
1 Post |
 Posted - 2007-09-11 : 01:45:10
|
| Hi ALL,Please let me know what backup process should be implemented if my customer says data is very important and they should not be loss of any data even for 1 mins. I have OLPT database and if take full backup at night and every 5 mins transaction log backup let's say transaction backup at 9:00am then next at 9:05am but let say database crash at 9:04am how to recovery data for 4 mins. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-11 : 01:54:58
|
Depends a bit on the type of crash. We have had disk failure on the MDF spindle which has trashed the database, but we were able to make the final TLog backup (LDF files on a different spindle), and then restore the database, and Tlogs, with ZERO lossBut if the server caught fire the most recently backup wold be all we could recover to.  Beyond that you would need replication to a second server - i.e. each data modification transaction would need to be using a 2 phase commit, and not committed until the transaction as also replicated to a second machine.I had also heard of disk-mirroring systems that will replicate the disks to a remote location, sorry can't remember the name of that technology.Kristen |
 |
|
|
|
|
|
BACK UP