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 5 years, 1 month 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....

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

            
July 4, 2019 at 3:47 am
            
#3659969

            
            
                                                
        

A user does not require explicit SELECT permissions on the table to view data through a VIEW, as long as the user has SELECT permissions on the VIEW.

Granting the user...

Are you getting any error message?

You can read this blog: https://www.mssqltips.com/sqlservertip/1914/sql-server-database-partitioning-myths-and-truths/

I agree with Sue,

You are selecting the file from SQL Corrupt File folder. what does it mean?