Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS database 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.

Thanks.

share

migration rejected from stackoverflow.com Sep 27 '13 at 16:58

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, StanleyJohns, dezso, bluefeet, Kin Sep 27 '13 at 16:58

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, StanleyJohns, dezso, bluefeet, Kin
If this question can be reworded to fit the rules in the help center, please edit the question.

    
Try scripting out the Restore command and then executing it from a query window. –  RBarryYoung Dec 13 '12 at 16:34
    
@ marc_s, sure :-) –  khaled Dec 13 '12 at 17:53
    
@RBarryYoung, Not even has rights to script. same message. –  khaled Dec 13 '12 at 17:54
    
I'm looking at using RDS at the moment and I dont think what you want todo is supported. Have a look at the FAQ aws.amazon.com/rds/faqs/#23 -> Are you using the automatic backups or DB snapshots? –  MarkPm Dec 14 '12 at 8:30