Restoring backup

[JohnRoyal]

Using Google Cloud SQL for an MS SQL database (not MySQL)

Is there any way to empty a database so that I can restore a backup to it?

Or is the only way to create a new instance?

[Chris Rasco]

You shouldn't need to do that. Per the docs:

When you restore from a backup to the same instance, you return the data on that instance to its state when you took the backup.

https://cloud.google.com/sql/docs/mysql/backup-recovery/restoring#restorebackups-same-instance

https://cloud.google.com/sql/docs/mysql/backup-recovery/restoring#restorebackups-same-instance

https://cloud.google.com/sql/docs/mysql/backup-recovery/restoring#restorebackups-same-instance

[Katayoon (Cloud Platform Support)]

Hello,

As Chris mentioned, You can restore your Cloud SQL Server instance from a backup by following the steps noted here. If you would like to import your backup only for a database on your existing instance, You may look into the instructions on how to 

Importing BAK files to Cloud SQL.