I am very new to SQL Express. A database is located on a local machine. When I try to do a backup I get the following error:
Backup failed for server ‘server name’
(Microsoft.sql server.Express.smo)
Additional information:
Set property Devices to accomplish this action.
(Microsoft.sql server.Express.smo)
Their IT tecnicians insits that I have full administrative rights.
I am lost for a solution.
Would it be wise to shrink the database, detach from the database and copy both the mdf and idf to a different machine? I have never done this procedure before.
Please help.
Could you please send over the executed script ?Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||I am having same problem.I am connected to sql server 2000 instance.
When trying to backup the database i got the same error
Any idea why ?|||
Which Gui are you using ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
Sql Server Management Studio|||
|||Could you please then post the resulting Backup SQL command which is available through the script functionality within the Backup UI.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Did anyone get a resolution to this? I'm having the same problem. I uninstalled and reinstalled SQL Server 2005 Express and then reinstalled and it worked fine. I was able to back up the database for two days. Then the error started coming up again and now I'm getting the "Set property Devices to accomplish this action." error again.
I have no clue what property device it's talking about or where to set them. Any help would be greatly appreciated!
Thanks,
Steve
No comments:
Post a Comment