The following are the restrictions for a restore:
- The database to be restored must not be a snapshot database.
- A database snapshot is a read-only, static view, of a SQL Server database (the source database). The database snapshot is consistent transaction-wise with the source database as of the moment of the snapshot creation. A database snapshot always resides on the same server instance as its source database. As the source database is updated, the database snapshot is updated.
- The database to be restored must not have snapshot databases.
- The database to be restored must not be mirrored. This means it should not have an active mirroring session.
- A database is not restored if it is part of an Availability Group. AppSync removes the database from the Availability Group as part of the restore process but does not put the database back into the Availability Group after the restore process completes.