Thanks Gail, your solution help me a lot for which I was struggling last 3 days 🙂

I resolved the issue...following KB helped me..

http://support.microsoft.com/kb/947462.

Just a thought, have you added any linked server in PROD after you tested DR solutions previously and the same linked server is not added to your DR? and hence...

Steve, this one was very easy :-), still 17 % got it wrong when I answered this...so those folks got to learn something though..

Until there are open/active transactions using the VLFs at the end of transaction log file, the shrink will not release the space.

Follow the guidelines, I think this should help you

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

Got to learn something, I am yet to explorer SSIS settings may be I will understand it clearly when I get the time to learn SSIS in detail...

Hi Brian,

This is quite interesting while reading :-), need to implement it on my test env before I can comment anything....but its sure lot of efforts had been put...

Thanks Gail, for detailed article. This is very useful and this goes to briefcase 🙂

I was pretty sure about owner of master db cant be changed and master db can't be mirrored..still I selected participate mirror option :-D...and after I clicked submit I realised...

I got one correct, one wrong...:-D....

Some of the names I know very well and some I thought I heard(which made me to select the one which went wrong, and one...

Mike,

Thanks for this wonderful guide....

Shailendra

Is this the maintenance plan for performing backup? If it is, check maintenance plan history it may give you more informational error message. Did you checked the event log and...

Easy one 🙂

As I understand your requirements, let me try to put the solution in simple way:

1) You need autofailover and syncronization between databases -- Opt for SQL Server failover cluster

Actually in...