Error in backing up database

2018-07-03 14:17:49

I want to backup a database from our main server. But this error happens

System.Data.SqlClient.SqlException (0x80131904): Cannot open backup device 'C:Tempsample.bak'. Operating system error 3 (The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
ClientConnectionId:d9c1c173-e60e-4e07-91d6-2ba43b905ff6

Thank you for your help!

The query I tried is

BACKUP DATABASE H2RPDB_v2 
TO DISK = 'C:Temptest2.bak'

in SQL Server. H2RPDB_v2 is from my remote server.

The error indicates that the path doesn't exist. Does C:Temp exist? If so, does the service account have access to the folder?

Other things might be storage is full, etc.

See related question: SQL server 2008 backup error - Operating system error 5(failed to retrieve text for this error. Reason: 15105)

链接地址: http://www.djcxy.com/p/93598.html