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 ????