Activity overview
Latest activity by js_0505
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...
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...
SQL Backup, Diff, Log
Okay I am currently doing a full backup every sunday and a differential backup every 15 minutes. I am sightly confused why some do log shipping between differentials and how it is benficial? A di...
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...
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
Log Shipping Problem
When I try to set up log shipping for a 10+gig db it fails when the logshipping backup occures. I go through all of the steps as smaller db's do not have issues at all. Once the backup is created...