I am trying to restore a native backup directly from Amazon S3. I have tried setting up a direct restore using xp_restore_automated as well as running a one time restore through the UI. When I try to restore the backup through the UI, I get the message "Cannot find table 0" when trying to add the backup file.
When I try to restore using the extended stored procedure, I get the failure below.
LiteSpeed™ for SQL Server® Version 220.127.116.11 (64bit) © 2014 Dell Inc. [SQLSTATE 01000] (Message 1) Failed to RESTORE LABELONLY (Maybe file "s3:\\torrentdb-backups\PRD-SQLA-EC2-W\prd-clst1-ec2-w$prd-clst-sql-ag_TorrentFlood_FULL_20150208_030026.bak" is not in Native format) [SQLSTATE 42000] (Error 853). The step failed.