IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

"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:
578
Contributors