Moving database from one server to another
Are you getting the error on the destination server? 

Is the path present on the destination server?

You need to make sure that the paths defined in your CREATE DATABASE script exist on the destination server or you need to create them there.