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 ...
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 ...
I am running into 'transaction log full' issue with SQL Server 2008 R2. My database includes 80,000 tables which contains up to 5 columns of BIGINT and there is an index for each columns. The ...
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 ...