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:
|
1
|
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:
|
1
|
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:
- Open [Control Panel] -> [Administrative Tools] -> [Services] -> [Online Backup Scheduler] -> [Log on]
- Select the [This Account] option
- Enter the Login Credentials
- 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:
- Open [Control Panel] -> [Administrative Tools] -> [Services] -> [SQL Server (MSSQLSERVER)] -> [Log on]
- Select the [This Account] option
- Enter the Login Credentials
- Restart the [SQL Server (MSSQLSERVER)] service
