Hello all,
My DB is MSSQL 2005. always there is a case when there is some problem reported by the users and i need to login to the production DB and check it. i want to create a mirror of DB on the same box so that instead of login in direclty to production, i could check the same on that mirror.

How can i do this mirroring?
any link also most appreciated