I recently upgraded my local SQL Server to Version 2014, which also installed the SSMS 2014.
When using SQL Server Management Studio 2014 to create a backup (both local and remote, Server Versions 2008 - 2014), I get the following error:
To accomplish this action, set property Devices.
In the dropdown I chose Disk and I've also chosen a path for the backup. The path exists on the server and I've got full permission on this path.
If I use the old SQL Server Management Studio 2012 with the same settings, the backup works without any issues.
It also works using T-SQL
BACKUP DATABASE SOMEDATABASE TO DISK = 'D:\SomeDir\SomeDataBase.bak' WITH COMPRESSION
So the issue has to be specific with the Management Tools Version 2014.
The only solutions I found on the internet were due to missing path, which isn't the case for me.
Has anyone experienced and/or solved this issue?
Edit: Added Screenshot (UI in German)
- Vollständig: Full
- Datenträger: Disk
Media and security options unchanged. Master database was just taken as example, happens to every other database.
The problem seems to be related to me using an English language pack on a German Windows and a German SQL Server 2014 installation. If the Windows display language is set to German, the issue disappears. If the Windows display language is set to English, the issue reappears.
Thanks for all contributions.