April 12, 2012 at 2:35 am
Hi,
I want to know regarding Mirroring configuration on two different server
1. Is it neccessary the service account user of SQL Server Agent and and SQL Server user must be same on both server?
2. If i change service account and sql server account to the same user will it effect the application connected with the principal server?
2. I have taken Database backup and transaction log and restored on the mirror server but when i click on the Start Mirroring it gives me the following error.
"The remote copy of database has not been rolled forwarded to a point in time that is encompassed in the local copy of the transactional log. . (Microsoft SQL Server, Error 1412)"
Thank you.
April 12, 2012 at 2:59 am
The service accounts does not need to be the same. You communicate through the endpoints.
After both the database and the tail of the log was backed up, make sure that you have restored the database with the NO_RECOVERY option.
April 12, 2012 at 4:37 am
farrukh635 (4/12/2012)
1. Is it neccessary the service account user of SQL Server Agent and and SQL Server user must be same on both server?2. If i change service account and sql server account to the same user will it effect the application connected with the principal server?
Mirroring is handled by database engine, not by SQL Server Agent.
Mirroring works even when SQL Agent is not running.
May be you need SQL Agent for sending Alert or something like that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply