Archive Shuttle uses the following Databases:
- The Archive Shuttle Directory database. There is just one of these; it hosts all configuration and non-item based metadata.
- The Archive Shuttle Item database(s). There is one of these for each source Link (e.g. one per Vault Store). These databases do not have to be on the same SQL Server as the Archive Shuttle Directory database. Each Item Database can be on a separate SQL Server, if required.
Microsoft SQL Server must be installed and set up before you install Archive Shuttle. The collation requirement for the SQL Server installation must be case-insensitive, accent-sensitive (CI, AS); case-sensitive and accent-insensitive installations are not supported.
Microsoft SQL Server must be on a dedicated server, either physical or virtual. It is not supported to have it on the same server as the Archive ShuttleCore server. It is not supported to have the Microsoft SQL Server shared with any other software, for production use.
Before installing the Archive Shuttle Core Components, make sure the account that will be used has “dbcreator” rights in Microsoft SQL Server.
SQL Server Version
The following versions of SQL Server are supported with Archive Shuttle:
|SQL Server 2005||No|
|SQL Server 2008||No|
|SQL Server 2008 R2||No|
|SQL Server 2012||Yes|
|SQL Server 2014||Yes|
|SQL Server 2016||Yes|
|SQL Server 2017||Yes|
Note: Having the latest service pack installed is recommended.