Biztalk Database Question:

What is transfer Upgrade?

Biztalk Database Interview Question
Biztalk Database Interview Question

Answer:

In this type of upgrade, you simultaneously upgrade the version of SQL Server and move the databases to a new instance of SQL Server or to a new location entirely. You must manually move the databases and other objects (such as logons and jobs) to the new location. The procedure for a transfer upgrade is based on the procedure described in this topic, with the addition of the steps needed to move the databases to a new server or a new instance of SQL Server.


Previous QuestionNext Question
Explain how would you define database role in context to BizTalk?Tell us messages without subscribers are removed, how?