1
vote
1answer
69 views

Seeking Opinions - Is it a good idea to rely SQL backup 100% on transaction logs? [closed]

I'm in the midst of changing my company's SQL Server backup practice. We use to create full backups weekly and daily differential backups overnight. The issue is that as these full backups grow, it ...
1
vote
3answers
137 views

How frequent can we do SQL transaction log backups?

I'm installing a highly critical system. If the system fails, the users wants data up to the last minute. To achieve this, I was thinking of running Transaction Log Backups + FTP every minute. Has ...
1
vote
2answers
108 views

need scalable, highly available transactional log server

My requirements: 1) must be able to continue operating after node failure 2) logs must be recoverable after node failure - no data loss 3) must be able to scale out 4) must be transactional - when a ...
2
votes
6answers
529 views

SQL Server transaction log backups,

I have a question regarding the transaction log backups in sql server 2008. I am currently taking full backups once a week (Sunday) and transaction log backups daily. I put full backup in folder1 on ...