- Product Version:
- Problem Description:
- Cause:
- Resolution:
ServosityPro: All
OS: Windows
OS: Windows
When performing a MS SQL database backup, the following warning message is received in the backup report:
or
|
or
|
The message suggests that ServosityPro 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 by the ServosityProscheduler, please verify if the "Log on" account of the ServosityPro scheduler service has sufficient permission to access the designated temporary directory:
1. Open [Control Panel] -> [Administrative Tools] -> [Services] -> [Online Backup Scheduler (ServosityPro)] -> [Log on]
2. Select the [This Account] option
3. Enter the Login Credentials
4. Restart the [Online Backup Scheduler (ServosityPro)] service
In the cases where ServosityPro 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
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 by the ServosityProscheduler, please verify if the "Log on" account of the ServosityPro scheduler service has sufficient permission to access the designated temporary directory:
1. Open [Control Panel] -> [Administrative Tools] -> [Services] -> [Online Backup Scheduler (ServosityPro)] -> [Log on]
2. Select the [This Account] option
3. Enter the Login Credentials
4. Restart the [Online Backup Scheduler (ServosityPro)] service
In the cases where ServosityPro 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