Activity overview
Latest activity by chump!
Well I'm open for suggestions on next steps. / comments
Well I'm open for suggestions on next steps.
Close except for the transaction log part.
The logshipping wizard does not create a transaction log job until the backup has completed and since it takes 6 hours to complete there are 24 missing transaction log files.
I have tested and verified this is the case.
Is there anyway to have the wizard start the transaction job at the begining of the database backup? / comments
Close except for the transaction log part.
The logshipping wizard does not create a transaction log job until the backup has completed and since it takes 6 hours to complete there are 24 missing tr...
Bump / comments
Bump
So is there an issue with the length of time it takes to copy the database or to restore the database that when the first transaction log restore kicks off it thinks it's out of sync?
I have setup and tested a small database and that works fine but when setting up log shipping with the large database (45 GB - 4.5 GB compressed), the transaction log restore errors every time.
Reaching the end of my rope here. Anyone? / comments
So is there an issue with the length of time it takes to copy the database or to restore the database that when the first transaction log restore kicks off it thinks it's out of sync?
I have setup...
That's just it there is no other SQL Backup jobs other than the one I am attempting to setup via log shipping. / comments
That's just it there is no other SQL Backup jobs other than the one I am attempting to setup via log shipping.
Can some one enlighten me as to how this can happen when setting up log shipping for the first time to a new database? / comments
Can some one enlighten me as to how this can happen when setting up log shipping for the first time to a new database?
Log Shipping 101
I have been working with the Log shipping "feature" using the log shipping wizard with the latest version of sql backup 5. We are attempting to setup log shipping to a remote location across a vp...