How can we Help ?

SQL Error: Path does not exist!

When performing a MS SQL database backup, the following warning message is received in the backup report:

Path "\Temporary_Directory\Backup\MSSQLServer\Backup_ID" does not exist!
Or
Path "Microsoft SQL Server\SERVER\Directory_Path" does not exist!  

The message suggests that backup software cannot locate the database file from the designated temporary directory.  To resolve the issue, please verify if the database file in concern can be spooled successfully. To do so, please enter the following osql command on the MS SQL server in concern:

Example with Windows Authentication mode:

osql -E -Q "DECLARE @dbname char(64) SET @dbname = 'xxx' BACKUP DATABASE @dbname TO DISK = 'C:\temp\testdump.txt' WITH SKIP"

OR
Example with SQL Server Authentication mode:

osql -U USERNAME -P PASSWORD -Q "DECLARE @dbname char(64) SET @dbname = 'xxx' BACKUP DATABASE @dbname TO DISK = 'C:\temp\testdump.txt' WITH SKIP"

Notes:
xxx is the name of your database

If the error only occurs on a backup job performed when scheduled and not manually, please verify if the "Log on" account of the backup software scheduler service has sufficient permission to access the designated temporary directory:

  1. Open [Control Panel] -> [Administrative Tools] -> [Services] -> [Online Backup Scheduler] -> [Log on]
  2. Select the [This Account] option
  3. Enter the Login Credentials
  4. Restart the [Online Backup Scheduler (backup software Advanced)] service


In the cases where backup software is not installed on the SQL server, please verify if the "Log on" account of the MS SQL Server (MSSQLSERVER) service has sufficient permission to access the designated temporary directory:

  1. Open [Control Panel] -> [Administrative Tools] -> [Services] -> [SQL Server (MSSQLSERVER)] -> [Log on]
  2. Select the [This Account] option
  3. Enter the Login Credentials
  4. Restart the [SQL Server (MSSQLSERVER)] service
Average rating:0 (0 Votes)

Contact Information

  • XZBACKUP
    2850 Interstate Dr. #2, 33805
    Toll-Free: +1 800.213.2157
    US Local: +1 727.564.9230
    UK Local: +44 2036.080613
    Phone Hours: 9AM - 6PM EST
    E-mail: sales@xzbackup.com
    Website: www.xzbackup.com
Copyright © 2015 xzbackup.com. All rights reserved.