It seems media error ..try with reinstalling Sql sever again.

Check this link.

http://msdn.microsoft.com/en-us/library/ms144267.aspx

use filestream feature is best option for your requirement.

http://technet.microsoft.com/en-us/library/bb933993.aspx

Djcarpen11 (3/19/2012)

---

When I run sp_helpdb on one of our servers the owner of one of the databases is ~~UNKNOWN~~, If try to run EXEC sp_changedbowner 'SA' the command never completes...

satya,

Have you found anything in error log??

First of all, have you checked the mirroring monitor and event log of both principal and mirrored server?

Check this link.

http://en.wikipedia.org/wiki/Microsoft_SQL_Server

you can refer this book and it has nice examples.

Inside Microsoft SQL Server 2008: T-SQL Querying

take a help of google. your will find all the basics of sql server.

Database might be went in recovery pending state. check the error log as well for more information.

Check browser service is running or not?

Try with exploring dbcc memorystatus().

Create a windows group for developer and that group to your production server. give the required permission on that group.

here is the steps

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx

Are you executing any Stored procedure with param? check the execution plan also for any clue.