• Hi Vince,

    I've just used your 'sp_ABBackupRestore' facility to copy a live dotnetnuke website and restore it on my local server and it worked perfectly!

    Since then I've tried the same procedures with another ddn website and when I try to run the EXEC sp_ABRestoreDb command i get the following error:

    Server: Msg 3205, Level 16, State 2, Line 1

    Too many backup devices specified for backup or restore; only 64 are allowed.

    Server: Msg 3013, Level 16, State 1, Line 1

    RESTORE FILELIST is terminating abnormally.

    Server: Msg 50000, Level 16, State 1, Procedure sp_ABRestoreDb, Line 457

    Couldn't restore database A3250233 from file C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\A3250233.bak since the number/type of logical devices do not match.

    I've tried the whole process a few times and just keep getting stuck at this point. I'm running SQL Server 2000 on Windows Server 2003.

    Any ideas would be gratefully received!

    thanks alot,

    Jo