Comments
Sort by recent activity
So given the limited bandwidth because i am moving from server a in fl to server b tx, then I should keep a full bu going on sunday midnight and then what would you recommend for differential backups and transaction logs? If i create the jobs and set them all to start at midnight tonight, won't the transaction logs overlap between the full and differentials? The logs will move over to server b quicker then the differential. I am a little lost there on receiving the transaction logs while the differential bu is moving across the network. Thank you for your assistance. / comments
So given the limited bandwidth because i am moving from server a in fl to server b tx, then I should keep a full bu going on sunday midnight and then what would you recommend for differential backu...
Also, if i decide to include transaction logging, I will not be able to use the bu db because I would have to set the recovery to simple so there will be only a particular period of time that I can read data from the backup? Lastly, is there a way I can program red gate to restore the most recent differential automatically as a job. Like I would like the db to restore every hour with the most recent differential file. Right now they naming is automatic. / comments
Also, if i decide to include transaction logging, I will not be able to use the bu db because I would have to set the recovery to simple so there will be only a particular period of time that I can...
The error is LSN*** is newer please use log file that contains LSN***. The problem is the first LSN generated after the backup is not insync with the backup. i am using SQLBackup 5.4 / comments
The error is LSN*** is newer please use log file that contains LSN***. The problem is the first LSN generated after the backup is not insync with the backup. i am using SQLBackup 5.4
I have also noticed that the first transaction log backup occures only after the full backup restores and that restore job takes 2 hours and there are transactions taking place during the restore of the Backup(full) and the first run of the Transaction Log Backup. / comments
I have also noticed that the first transaction log backup occures only after the full backup restores and that restore job takes 2 hours and there are transactions taking place during the restore o...