tags:

views:

19

answers:

0

while retrieving data and log files of Mirror Database(Ex:TestDB) using EnumFiles() of sql dmo seeing following error:

ERROR: Microsoft SQL-DMO (ODBC SQLState: 42000) [Microsoft][ODBC SQL Server Driver][SQL Server]The database "TestDB" cannot be opened. It is acting as a mirror database.

so can anyone please tell me how to retrieve all the data and log files of mirror database?