• 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.