Check this reference: https://www.mssqltips.com/sqlservertip/5526/how-to-setup-and-use-a-sql-server-stretch-database

You could use the following command which returns the URL of the backup file:

SELECT *

FROM managed_backup.fn_available_backups ('databasename')

For more details, please refer to https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/managed-backup-fn-available-backups-transact-sql?view=sql-server-ver15.

Hope this could help you.

You may read these blogs: how to attach SQL database without LDF

https://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/

https://www.stellarinfo.com/blog/attach-sql-database-without-transaction-log-file/

No, you cannot get URL from GUID. The backup most probably would be done on Blob contained in the Azure storage account. You can reverse engineer to find it out

RESTRICTED_USER Access Mode

In RESTRICTED_USER access mode, only the users who have db_owner or db_creator permission can access. Users who belong to the sysadmin fixed server role can also access the...

SQL 2019 is in very early days

I would suggest SQL 2017 as its the latest stable version available.

SQL 2019 has, in addition, some integration features with external sources but it's...

• This reply was modified 6 years, 7 months ago by prettsons.

No, is not possible to downgrade a database. There is absolutely no way you can restore or attach this database to the SQL Server 2016 instance you are trying to...

There are a few limitations for restoring the filegroup:

• The system administrator restoring the files and filegroups must be the only person currently using the database to be restored.
• RESTORE...

I read each and every line of this conversation. Thanks, Alejandro for posting this issue very clearly and updating it. I agree with @jeff and @steve-2. I found this doc...

When you take a backup, you have the following options:

Media Options:

Option to overwrite media

• Append the existing backup set
• Overwrite all existing backup set

In my...

These are the steps to restore the database from suspect mode:

Turn off the flag and set the database to EMERGENCY

EXEC sp_resetstatus ‘db_name’;
ALTER DATABASE db_name SET EMERGENCY

SQL Database Recovery Expert 🙂