Unable MSSQL database backup - SQL Server management studio

66carolin · #1 (**permalink**) 05-16-11, 04:10

Hi!
I have a VPS. I want to take the MSSQL database backup with SQL Server management studio. But there is an error :

Quote:

Backup failed for Server 'SERVERNAME\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)

------------------------------
ADDITIONAL INFORMATION:

To accomplish this action, set property Devices. (Microsoft.SqlServer.SmoExtended)

What can I do now?

77wmaster · #2 (**permalink**) 05-16-11, 04:26

Did you clearly describe the path for the backup file to a valid location?

Please make sure the location really exists. If you connect to a remote SQL Server instance, the backup file will be created in the path you specify on the server machine.

PATRICIAF5 · #3 (**permalink**) 05-16-11, 04:33

I am facing the same error while taking backup.
I have specified the proper path but still same error.
Any thing else we require to check ?