June 13, 2011 at 10:19 am
How to i find, till where my mirror database is synchronized with primary database.
because there are many log files, its showing synchronizing most of time.
June 13, 2011 at 10:25 am
Have you looked at the Database Mirroring Monitor in SSMS?
June 13, 2011 at 11:00 am
I think from SSMS database monitor
we can only find the status but i want to know till which transaction log backup its been mirrored.
is there any way i can find?
June 13, 2011 at 2:17 pm
4u.chethan (6/13/2011)
I think from SSMS database monitorwe can only find the status but i want to know till which transaction log backup its been mirrored.
is there any way i can find?
There is no relationship between a transaction log backup - and mirroring. The mirroring process does not work off of the backups, just the transaction log itself.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 10:57 pm
Check the LSN number of Transaction Log Backup File,you can check also this LSN information from backupset in the msdb database
then verify this back_set_id in the msdb restoreFilehistory table on the mirror Server
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 13, 2011 at 11:45 pm
Syed Jahanzaib Bin hassan (6/13/2011)
Check the LSN number of Transaction Log Backup File,you can check also this LSN information from backupset in the msdb databasethen verify this back_set_id in the msdb restoreFilehistory table on the mirror Server
I'm sorry, but how are you going to check the restorefilehistory on the mirror server when no restores are being done on the mirror server? Database mirroring does not use the backup/restore processing of SQL Server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply