I'm trying to setup an SQL Server 2005 mirror, but I got the following error:
"sql server The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log"
When using a sample database (size less than 10 MB) it works, but when I use a 7 GB database, it fails.
I'm not using encryption.
I also tried to perform several log backup & restore just in case, but it doesn't work.
The only thing that may affect is that servers are in different timezones. But why does it work with a small DB and not with a 7 GB DB ?
Mirror database is restored using "norecovery" option.
It does work for 10 MB database, but does not work for a 7 GB database, which takes about 15 minutes to be restored on target instance
Any idea ?
Thanks a lot,