Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

"Cannot open backup device" error when running test harness tool batch file

"Cannot open backup device" error when running test harness tool batch file

Version

7.2.x.

 

Issue

Receiving an error when running the test harness tool batch file.

 

Symptoms

Error: Cannot open backup device.

 

Cause

Missing a parameter on the command when running the test harness tool batch file.

 

Solution

Use this syntax:

SqlPerformanceTest.Bat . "<full file path and name of .bak file that came with the batch file here without the brackets but keep the quotes>" "<partition drive>:\mssql\Data\MSSQL10_50.MSSQLSERVER\MSSQL\DATA" "<partition drive>:\mssql\Log"

 

Example (if the batch file and all the other files for the tools were saved on the C:\temp and SQL partitions are in E and F drive):

SqlPerformanceTest.Bat . "C:\temp\backup.bak" "E:\mssql\Data\MSSQL10_50.MSSQLSERVER\MSSQL\DATA" "F:\mssql\Log"
Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎01-07-2015
Views:
361
Contributors