SQL Server Management Studio - SSMS doesn't show BackUp and Restore options on Tasks menu

514 Views Asked by At

I'm tying to transfer one sql database from one Azure account to another. One way to do this is documented by Microsoft here [Restore a Backup from a Device (SQL Server)], where they recomend to use BackUp and Restore options, but these options don't exist in my Task Menu:

enter image description here

I'm using SSMS V18.8 and the databases are hosted on Azure. Both source and destination server are in two different Azure accounts. I spent a lot of hours and didn't get a solution. Neither to show the options or using another way to transfer the database.

0

There are 0 best solutions below