• A with Move error usually means that the database restore is trying to put the data and log file in the same location as the server that it was backed up from.  For example, on one server we store our data files on the root of E:\ on another server they are stored at d:\data\.  If I try to restore a backup from the first server to the second it will try to put the files at E:\.  If that location does not exist then I will get an error telling me to use the with move clause.  The syntax I use is as follows:

    RESTORE DATABASE [dbname] FROM  DISK = 'path to backup file'

    WITH  FILE = 1,  NOUNLOAD ,  STATS = 10,  RECOVERY ,  REPLACE , 

    MOVE 'nameofdatafile' TO 'new physical location of the data file'

    MOVE 'nameoflogfile' TO 'new physical location of the log file'