I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database instance. When I start restoring a given database I'm able to see all full backups and transaction logs, but it gives me this error message when trying to restore
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The EXECUTE permission was denied on the object 'xp_fileexist', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
I can restore a full database instance from AWS management console, but that is not what I want. I want to be able to restore a given database to a specific point-in-time and not restoring a whole new database instance. Also looks there isn't much information on how to restore to a specific point-in-time.