Must declare the scalar variable "@path". (.Net SqlClient Data Provider) in ssm 2017.1

3
votes

Hi I install Microsoft sql server 2016 with management studio 17.1 and i had database backup from sql 2014, now want restore my backup to new sql server when click on "..." opposite of device, and open new windows to add Click on "add" button then get this error '

Must declare the scalar variable "@path". (.Net SqlClient Data Provider) '

how can i resolve that

3
sqlsql-serverdatabase-restore
How are you trying to restore? – Fabiano Carvalho
Yes , restore and attach , get the same error. – sunny
Post your code. – Jacob H
I don't use any Code only start restore from sql management studio . – sunny
I don't use any Code only start restore from sql management studio . right click on sever > task> restore > with out any more think when click , click on device and then in new windows click on add ==> get above error – sunny

3 Answers

0
votes

with script i cant do that, in finally i use from import data wizard from remote server to local for solve this problem

0
votes

Download the latest SSMS 17.9 version and try. They have fixed the bug