the mirrored server is always in the state of restoring only

The database in Mirrored server is always in the state of restoring only.

the database in mirrored server is restored with norecovery

then we started mirroring.

the status of mirroring is successfull and is synchronized.

but the Mirrored server is always in the state of restoting

not allowing use to open the database.

could any one know why this problem is comming and give some solution for this problem so that the mirrored database can be accessible opened and queryed to really verfiy that the changes made in principal database is mirrored to Mirrored database.

[817 byte] By [srkumar] at [2008-3-5]

«« Excel wrapper missing members/functions
»» Row height issue on export to Excel

# 1

the mirrored database is deliberately inaccessible as it is in a constant state of recovery. If you want to verify the changes are really mirrored try failing over to the mirror after comitting a couple of transactions and examining the database on the mirror when this is the primary. These transactions should have been hardened to the mirror.

If you want to access the mirror for querying purposes you can create a database snapshot of the mirrored db. Bear in mind that this is a snapshot though, so it will only contain transactions committed at the time the snapshot is generated.

thx, Simon.

SimonRapier at 2007-9-10 >

top of Msdn Tech,SQL Server,Database Mirroring...

# 2

Hi Simon,

Thank you very much as per suggestion i tried and its working as fine thabk you very much.

srkumar at 2007-9-10 >

SQL Server

Database Mirroring

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech