In this blog post, let’s learn about the error message “14908 – Cannot set REMOTE_DATA_ARCHIVE to OFF from ON. To retrieve remote data and turn off remote data archive, set REMOTE_DATA_ARCHIVE (MIGRATION_STATE = INBOUND). To turn off REMOTE_DATA_ARCHIVE without retrieving remote data, set REMOTE_DATA_ARCHIVE = OFF_WITHOUT_DATA_RECOVERY.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
14908 – Cannot set REMOTE_DATA_ARCHIVE to OFF from ON. To retrieve remote data and turn off remote data archive, set REMOTE_DATA_ARCHIVE (MIGRATION_STATE = INBOUND). To turn off REMOTE_DATA_ARCHIVE without retrieving remote data, set REMOTE_DATA_ARCHIVE = OFF_WITHOUT_DATA_RECOVERY.
Reason for the Error
To be update soon…
Solution
To be update soon…