This, my dears, is telling it how it is.

Sorry, I thought you were implementing native SQL Server mirroring. I don't know enough about SAN mirroring to give a qualified answer.

Wouldn't the mirror be on standby? Therefore you wouldn't be able to run SQL against it. To get round this, you would have to create a snapshot against the mirror.

I love Paul's first reply to this Fair play to the OP, at least he added attachments;-)

Dress well.

www.dba-oracle.com/dress_code.htm

😉

Thanks for getting back to us Chandu - we thought we had lost you. May I ask, is your database 800TB? What type of data / business area are you...

I hope the OP returns to clarify the situation. Perhaps he will when he has finished lugging the backup tapes onto the truck...

Me too.;-)

select * FROM sys.messages in sql 2005

There is a maximum of 1024 columns per table. You would ned to create two tables with a common key and then select across both tables.

Is the table design fully...

Why would you even want to do this? Seriously. What is the design rationale for it?

Thanks for your reply Piotr.

I was thinking along that avenue, its just that the client has a policy of not using SQL Agent. They run all there scheduled jobs from...