• I donwloaded the scripts from Phil Cruz

    (http://philcruz.com/blog/2006/04/more-intelligent-backup-and-restore.htm)

    The Backup part works like a charm but when I tried to run the Restore part I got the following error:

    THIS IS WHAT I AM TRYING TO RESTORE

    EXEC sp_ABRestoreDb 'dnndb', 'c:\Temp\dnndb.BAK'

    THIS IS THE ERROR

    RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'

    Msg 22001, Level 1, State 1

    Msg 213, Level 16, State 7, Line 1

    Insert Error: Column name or number of supplied values does not match table definition.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE FILELIST is terminating abnormally.

    Msg 50000, Level 16, State 1, Procedure sp_ABRestoreDb, Line 458

    Couldn't restore database dnndb from file c:\Temp\dnndb.BAK since the number/type of logical devices do not match.

    Any Ideas ????