When i trying to load data from MS access (MDB) to SQL ,i am
getting the below error. Error: 0xC0209303 at Package, Connection manager "mdbfilename": SSIS Error Code
requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered -- perhaps
no 64-bit provider is available. Error
code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service
0x80040154 Description: "Class not
registered". Error: 0xC020801C at Data Flow Task mdbfilename, OLE DB Source : SSIS Error Code
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the
connection manager " mdbfilename
" failed with error code 0xC0209303. There may be error messages posted before this
with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at Data Flow Task mdbfilename,
SSIS.Pipeline: component "OLE DB Source" (1) failed vali…
An error occurred while starting mirroring.
Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo)
The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)
Log backup is not close enough to the mirror server database log. So restore is getting failing in the database mirroring session initiation.
Take latest principal database full and log backup with NO RECOVERY mode and copy the backups to the mirror server to restore it by the below order.Restore the full backup with no recovery mode.Then Restore the log backup with no recovery mode.Then start your database mirroring session.
If you are trying to restore the log backup before full backup, you will get the below error.
So the order of backup in the restore is very important. Full backup first and then Log backup to restore.