Here is the SQL2000 code (not that the SQL2000 Job Agent has a lower limit on the amount of chars allowed in the T-SQL statement so you have to put...

Here is my code for SQL 2008 (the RESTORE_FILELIST_ONLY gives different output based on SQL version).

PRINT 'Starting up...'

PRINT CONVERT(varchar(100),GETDATE(),121)

DECLARE @dest_dbname varchar(255)

DECLARE @source_path varchar(255)

DECLARE @dest_filepath varchar(255)

DECLARE @log_filepath varchar(255)

DECLARE @stage_db_data_dir varchar(255)

DECLARE @stage_db_log_dir...

We do basically the same thing in my environment.

1) Copy file to DEV server - I don't trust network connections during the restore, no one seems to handle them well

2)...