Restore filelist прервано с ошибкой астрал

Currently I receive the following error when executing script within a DTS package in SQL 2005 (it seems to be working in SQL 2000):

Processed 27008 pages for database ‘Marketing’, file ‘Marketing_Data’ on file 5.

Processed 1 pages for database ‘Marketing’, file ‘Marketing_Log’ on file 5.

BACKUP DATABASE successfully processed 27009 pages in 15.043 seconds (14.708 MB/sec).

(5 row(s) affected)

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.

The code I am using is:

— the original database (use ‘SET @DB = NULL’ to disable backup)

DECLARE @DB varchar(200)

SET @DB = ‘Marketing’

— the backup filename

DECLARE @BackupFile varchar(2000)

SET @BackupFile = ‘C:SQL2005 dbsMarketing.dat’

— the new database name

DECLARE @TestDB2 varchar(200)

SET @TestDB2 = datename(month, dateadd(month, —1, getdate())) + convert(varchar(20), year(getdate())) + ‘Inst1’

— the new database files without .mdf/.ldf

DECLARE @RestoreFile varchar(2000)

SET @RestoreFile = ‘C:SQL2005 dbs’ + @TestDB2

DECLARE @RestoreLog varchar (2000)

SET @RestoreLog = ‘C:SQL2005 dbs’ + @TestDB2

— ****************************************************************

— no change below this line

— ****************************************************************

DECLARE @query varchar(2000)

DECLARE @DataFile varchar(2000)

SET @DataFile = @RestoreFile + ‘.mdf’

DECLARE @LogFile varchar(2000)

SET @LogFile = @RestoreLog + ‘.ldf’

IF @DB IS NOT NULL

BEGIN

SET @query = ‘BACKUP DATABASE ‘ + @DB + ‘ TO DISK = ‘ + QUOTENAME(@BackupFile, »»)

EXEC (@query)

END

— RESTORE FILELISTONLY FROM DISK = ‘C:tempbackup.dat’

— RESTORE HEADERONLY FROM DISK = ‘C:tempbackup.dat’

— RESTORE LABELONLY FROM DISK = ‘C:tempbackup.dat’

— RESTORE VERIFYONLY FROM DISK = ‘C:tempbackup.dat’

IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB2)

BEGIN

SET @query = ‘DROP DATABASE ‘ + @TestDB2

EXEC (@query)

END

RESTORE HEADERONLY FROM DISK = @BackupFile

DECLARE @File int

SET @File = @@ROWCOUNT

DECLARE @Data varchar(500)

DECLARE @Log varchar(500)

SET @query = ‘RESTORE FILELISTONLY FROM DISK = ‘ + QUOTENAME(@BackupFile , »»)

CREATE TABLE #restoretemp

(

LogicalName varchar(500),

PhysicalName varchar(500),

type varchar(10),

FilegroupName varchar(200),

size int,

maxsize bigint

)

INSERT #restoretemp EXEC (@query)

SELECT @Data = LogicalName FROM #restoretemp WHERE type = ‘D’

SELECT @Log = LogicalName FROM #restoretemp WHERE type = ‘L’

PRINT @Data

PRINT @Log

TRUNCATE TABLE #restoretemp

DROP TABLE #restoretemp

IF @File > 0

BEGIN

SET @query = ‘RESTORE DATABASE ‘ + @TestDB2 + ‘ FROM DISK = ‘ + QUOTENAME(@BackupFile, »») +

‘ WITH MOVE ‘ + QUOTENAME(@Data, »») + ‘ TO ‘ + QUOTENAME(@DataFile, »») + ‘, MOVE ‘ +

QUOTENAME(@Log, »») + ‘ TO ‘ + QUOTENAME(@LogFile, »») + ‘, FILE = ‘ + CONVERT(varchar, @File)

EXEC (@query)

END