I have a problem with running this script, it returns this error message:
--------------------------------------------------------
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\folder\abase1.bak'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
---------------------------------------------------------
I know it can't find abase1.bak because the real physical filename is database1.bak. Please, I'm not very good with SQL but I do have 150+ databases i want to import into MS SQL. Can anyone tell me where i need to look in the script to fix this up?
Thanks in advance for all helpful hints / solutions.