Running A Query On A Snapshot Database Fails.

Hello!


I'm trying to use mirroring + snapshots for reporting on a large database.

I've set up the mirrored database and created a snapshot.

Everything looks fine unil a run some queries on the snapshot.

Some queries work some don't. the error is this:


Msg 954, Level 14, State 1, Line 1

The database "test" cannot be opened. It is acting as a mirror database.



From what i can tell when he's trying to use an index for the query, the engine tries to use it from the mirror database.

eg.
this query works fine:
select top 10 * from dbo.table1

this query gives the error:
select top 10 * from dbo.table1 order by col1 desc




What's going on and how can i make this setup work?
thanks.