IT41723: SQL INSTANT ACCESS MODE AND TEST MODE RESTORES CANNOT BE RESTORED TO PRODUCTION ENVIRONMENTS.

APAR status

• Closed as documentation error.

Error description

• IBM Spectrum Protect Plus Sql INSTANT ACCESS and TEST MODE
  restores cannot be restored to production environments.
  
  
  The "Restoring SQL Server data" section of the online
  documentation should state these restore types cannot be
  restored to production.
  
  
  For example:
  
  
  NOTE: INSTANT ACCESS MODE and TEST MODE restore methods cannot
  be restored into production environments.
  
  IBM Spectrum Protect Plus Versions Affected: All Versions
  
  
  Additional Keywords: RESTORE SQL INSTANT ACCESS TEST
  TS009943743
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus Installation and User's guide      *
  * 10.1.10 and 10.1.11                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * Installation and User's guide  10.1.12. Note that this is    *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• The IBM Spectrum Protect Plus installation and users guide
  10.1.12 section ?Restoring SQL Server data?
  https://www.ibm.com/docs/en/spp/10.1.12?topic=server-restoring-s
  ql-data,  the descriptions of ?Instant access mode? and ?Test
  mode? have been updated:
  
  Instant access mode
  In instant access mode, no further action is taken after
  mounting the share. Users can complete any
  custom recovery by using the files in the vSnap volume. An
  instant access restore of an Always On
  database is restored to the local destination instance. Users
  cannot move instance access mode to
  production mode.
  Test mode
  In test mode, the agent creates a new database by using the data
  files directly from the vSnap
  volume. Users cannot move test mode to production mode.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels