debugsqlMinor
SQL Server Management Studio 2014 Backup - Set Property Devices Error
Viewed 0 times
errorserversqldevicespropertystudiomanagement2014setbackup
Problem
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
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)
Translation:
Media and security options unchanged.
Master database was just taken as example, happens to every other database.
Update 21.07.2015
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.
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 COMPRESSIONSo 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)
Translation:
- Vollständig: Full
- Datenträger: Disk
Media and security options unchanged.
Master database was just taken as example, happens to every other database.
Update 21.07.2015
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.
Solution
Here is my Answer for Error message "To accomplish this action, set property Devices. (Microsoft.SqlServer.SmoExtended)"
-
Make sure the User Account you are logged in as has DBO rights on both, the MASTER Db and the DB you want to backup.
-
Using the SQL Express Manager, Expand the SQL Server Objects in the left pane and find "Server Objects" then click on "Backup Devices"
Right Click and create a "New BackUp Device.." and call it the same as the DB to be backed up... pointing to a directory on your server (e.g.: C:\MySQLBackups...)
This will create an "empty file" with the .bak extention. (e.g. C:\MySQLBackups\DatabaseName.bak)
Then right-click on this new device created and select "Backup database"...
The rest is straight forward...
This worked for me... Good luck!"
-
Make sure the User Account you are logged in as has DBO rights on both, the MASTER Db and the DB you want to backup.
-
Using the SQL Express Manager, Expand the SQL Server Objects in the left pane and find "Server Objects" then click on "Backup Devices"
Right Click and create a "New BackUp Device.." and call it the same as the DB to be backed up... pointing to a directory on your server (e.g.: C:\MySQLBackups...)
This will create an "empty file" with the .bak extention. (e.g. C:\MySQLBackups\DatabaseName.bak)
Then right-click on this new device created and select "Backup database"...
The rest is straight forward...
This worked for me... Good luck!"
Context
StackExchange Database Administrators Q#89651, answer score: 7
Revisions (0)
No revisions yet.