This is the procedure I followed.
- Took the Full Backup on the Primary
- Restored it on secondary with No Recovery option
- Took the Log Backup on the Primary
- Restored it on secondary with No Recovery option
- Setup Endpoint on Primary and Secondary
- Configured Mirroring from Primary to secondary
In the Database Mirroring Monitor State is : Synchronized.
On the secondary server database the state is Mirror Synchronized / Restoring ). Its there for hours now.
I cant write the sql command to see if the data is synchronized.
Am I missing something?