hi is it possible, to use the mirrored database in sql server 2008 for reporting purposes.thanks in advance,i have one more question is it possible to move the loghipping database beteen servers without breaking the logshipping.thanks again
Hi,Sure, you can use your Mirrored database for the reporting purpose, to achieve this you should create a snapshot on mirrored database point all your reporting to it read article http://technet.microsoft.com/en-us/library/ms175511.aspx AFAIK, without breaking the LS we can not move it.Regards