I created an instance of SQL Server 2012 Std Sp1 & Windows Server 2012 VM package on Windows Azure evaluation version.
Then I connected to the SQL Server running on Windows Azure using my local SQL Server 2012 (Evaluation copy) installed.
Question: when I try to restore a backup from a .bak
file (C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\Database.bak
) to SQL Server running on Windows Azure, it doesn't even list the above file under SQL Server Management Studio > Restore Database > Select Backup from a File > Add > locate Backup file.
What is that?
May I know how can I restore my backup file stored in my local PC to the SQL Server running on VM instance of Windows Azure?