“Path ‘C:\Temp\MSSQLServer\xxxxxx0769567’ does not exist” Print

  • 0

If you get this error while you are doing MS SQL or MS Exchange backup, please try to use an UNC path (e.g. //server/share) in "Temporary directory for storing backup files" under [Backup Source Settings]. Please make sure that your backup software client is on the same machine as your MS SQL or MS Exchange. Please also ensure that you have included the appropriate “Network Resources Authentication for Windows” information in the "General" section of the backup set.

For MS SQL Server, you may want to check whether if it can spool the database file correctly by running the following command:

(Windows Authentication mode)

1
2
  osql -E -Q "DECLARE @dbname char(64) SET @dbname = 'xxx' BACKUP DATABASE
  @dbname TO DISK = '//server/share/abc.txt' WITH SKIP"


OR


(SQL Server Authentication mode)

1
2
  osql -U USERNAME -P PASSWORD -Q "DECLARE @dbname char(64) SET @dbname = 'xxx'
  BACKUP DATABASE @dbname TO DISK = '//server/share/abc.txt' WITH SKIP"


Note:


USERNAME/PASSWORD = the database username/password

xxx = the database that you would like to backup
//server/share/abc.txt = the location for the database spooling file


Was this answer helpful?

« Back