Make a Copy of a Microsoft SQL Server 2005 database from a Mirror Copy I have a SQL mirror database in Microsoft SQL Server 2005. I would like to get a copy of it as a new database so I have the ability to read, write, and backup the database.  

I cannot break the mirror and ALTER it to become a live database. This is a business requirement that we always have a copy on the other server.  

I need a method to pull the data and all other parts of the database (triggers, stored procedures, etc) out of it into another database without breaking the mirror. I have tried SQL Server backups, which do not work on mirrors or snapshots of mirrors, and running through the copy database wizard which also did not work.  

Is there any way to get a copy from the mirror database?
I agree this should be moved to the dba stack exchange, though since I answer there as well I will post it here should it be migrated.

The only way to access a mirrored database from the mirror server is through a database snapshot, which will require enterprise edition of SQL Server. It will also be READ ONLY, so this may not work for what you want.

The other alternative is to take the backups of the primary (these, I would hope, should be available) and restore them for your use somewhere else up to the time you need.

If using already taken backups is not possible, ask for a copy_only backup to be taken on the primary and given to you.