HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

SQL Server Management Studio 2014 Backup - Set Property Devices Error

Submitted by: @import:stackexchange-dba··
0
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 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)

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!"

Context

StackExchange Database Administrators Q#89651, answer score: 7

Revisions (0)

No revisions yet.