Share via

SQL DB Backup issue

Mohana Reddy 0 Reputation points
2024-11-27T07:51:42.7566667+00:00

I am using FortiClient VPN for accessing SQL DB. When trying to back up an Azure SQL Database using SQL Server Management Studio (SSMS) the backup option is not showing. So, I have used Export Data-tier Application option in the Tasks menu. Now getting errors like this. Can anyone suggest how to bypass VPN for getting backup successfully. Note: I am giving path of my local file. Below is the error I am getting. Screenshot 2024-11-26 130514.png

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,144 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
480 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,291 Reputation points
    2024-11-27T09:05:06.91+00:00

    Note: I am giving path of my local file.

    You can not access from Azure SQL Database local resources and this has nothing to do with VPN.

    Backup the database to Azure BLOB storage, see

    https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-and-restore-with-microsoft-azure-blob-storage-service?view=sql-server-ver16

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.