title: Overwrite Existing DB from Backup
body: <p>I'm attempting to bring a copy of our production database to our staging database.  They are on different RDS instances.  I tried using the native SQL Backup/Restore methods but I keep getting an error.<br>
  Code I ran on production:</p>
  
  <pre><code>exec msdb.dbo.rds_backup_database @source_db_name='DBName',@s3_arn_to_backup_to=N'arn:aws:s3:::path/to/backup/DBName2019-09-17.bak'
  </code></pre>
  
  <p>It worked just fine.  When I attempt to restore using this command (I ran this on the staging RDS instance):</p>
  
  <pre><code>exec msdb.dbo.rds_restore_database @restore_db_name='DBName',@s3_arn_to_restore_from='arn:aws:s3:::path/to/backup/DBName2019-09-17.bak'
  </code></pre>
  
  <p>I receive an error:
  Msg 50000, Level 16, State 1, Procedure msdb.dbo.rds_restore_database, Line 91
  Database 'DBName' already exists. Two databases that differ only by case or accent are not allowed. Choose a different database name.</p>
  
  <p>I've been googling for a bit and can't seem to find a definitive answer.  I have several databases on the staging RDS instance; I don't relish the idea of having to create a new RDS instance every time I want to bring a copy of production into staging...</p>
  
  <p>How do I restore a copy of production into staging without having to create a new RDS instance?</p>