Hello, Matt,

I misunderstood your original suggestion. I will see if the double backup method with one being copy only is acceptable and likely go that route. I will mark your original answer as the solution.

Thanks!
-AC

Hello, Matt,

Unfortunately, this does not work when doing the 'chained' backup of sql-server > backup files > gcs. It seems like restoring directly to sql server from a filesystem backup is not possible, which is fine. We can use a direct-to-gcs sql server backup and just not keep a local copy.

Thank you,
-AC

To clarify on my previous question, I would effectively like to do the direct-to-GCS backup, but also keep one copy locally

Hello, Matt,

Hopefully just one more question. I can definitely get it to back up sql server locally, then upload those backups to GCS. Is it possible to make it so that I can restore directly from gcs to sql server? Or will I need to restore the full and differential and transaction logs, then manually import them?

Thank you,
-AC

Thank you for the prompt reply Matt. I will test this out and update asap.