Accessing a mirror database without main database failover
Home > IT Answers > DataCenter > Accessing a mirror database without main data...
SQL Server Ask the Experts
2445 pts.
0
Q:
Accessing a mirror database without main database failover
Failover, Mirroring, Database mirroring, SQL Server database, Database Failover
How can I access my mirror database on a SQL Server without a main database failover?
ASKED: Nov 24 2008  7:53 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You can't. Database mirroring doesn't allow you to view the database which is acting as the mirror. Your only option would be to create a snapshot of the mirrored database and use that to look at the data. However this snapshot will not be update to date as the snapshot is a snap as the database looked when it was taken.
Last Answered: Nov 25 2008  5:15 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0