Thanks a lot for your time Scott and Brian.  Your point that of not shrinking the db/files unnecessarily is noted.

But I am unable to understand how this error has occurred...

My thanks to Jeff, Voldemar and Scott.

@jeff, I was thinking of getting the remote server name through some variable or a function in remote server while I missed...

• This reply was modified 3 years, 9 months ago by  Ram.

Haa.  How did I miss it? Such a simple solution!

That was a detailed answer. Thanks for taking time, Anthony.  I will use the resources section you have provided to prepare for the exam.

Now this may be subjective question, approximately...

• This reply was modified 4 years, 6 months ago by  Ram.
• This reply was modified 4 years, 6 months ago by  Ram.

Thank you for your time Coffman and Chris. The landing and the production are going to be 'big', so we prefer them to be in different physical servers - manageability,...