Comments
Sort by recent activity
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...
Well I'm open for suggestions on next steps. / comments
Well I'm open for suggestions on next steps.
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.
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...
Bump / comments
Bump
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?