I tried to send you an email as you requested but it came back undelivered. I am sure I have either your first name or last name wrong - or maybe both
If you don't mind, can you send it to luis @ kreko dot com
Thanks in advance. By the way, what kind of issues should I expect with this update, if Any?
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 1Too many backup devices specified for backup or restore; only 64 are allowed.Server: Msg 3013, Level 16, State 1, Line 1RESTORE FILELIST is terminating abnormally.Server: Msg 50000, Level 16, State 1, Procedure sp_ABRestoreDb, Line 457Couldn'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!
I am also getting an errror similar to yours when restoring after moving from SQL2000 to 2005 (see below). Did you resolve this?
RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'Msg 22001, Level 1, State 1Msg 213, Level 16, State 7, Line 1Insert Error: Column name or number of supplied values does not match table definition.Msg 3013, Level 16, State 1, Line 1RESTORE FILELIST is terminating abnormally.