Sets the current backups store used for configuration queries.
SET BACKUPS STORE TO <StoreName>
UsageUse this statement to set the current backups store. The current backups store dictates where ElevateDB will retrieve the list of avalable backups when queries on the Backups Table in the special Configuration Database are executed. The name provided must be a valid store name. You can find out which stores exist by querying the Stores Table in the Configuration database.
This statement is not persistent and is reset once the current session is disconnected.
SET BACKUPS STORE TO "Backups"
Required PrivilegesAny user can execute this statement.
SQL 2003 Standard DeviationsThis statement deviates from the SQL 2003 standard in the following ways: