Proper data types from sb 5.2 "RESTORE FILELISTONLY"

cluthy

I get an 'error converting numeric to numeric' error when running this script, but only on large backup files. I need to know the correct data types returned from the extended proc (I assume my data types are close, but not exact, perhaps off by the length of the numeric type(s)).

SqlBackup version is v5.2.2824. running on 64bit windows 2003 server R2, sql2005 sp2.

DECLARE @sqb_filelistonly_cmd VARCHAR(8000)
	SET @sqb_filelistonly_cmd = ' -SQL "RESTORE FILELISTONLY FROM DISK = [' + @backupfile + ']"'






	DECLARE @FILELIST TABLE
	(
		LogicalName VARCHAR(512),
		PhysicalName VARCHAR(512),
		FileType VARCHAR(8),
		FileGroupName VARCHAR(256),
		FileSize NUMERIC(20,0),
		FileMaxSize NUMERIC(20,0),
		FileID NUMERIC(20,0),
		CreateLSN NUMERIC(20,0),
		DropLSN NUMERIC(20,0),
		UniqueID VARCHAR(50),
		ReadOnlyLSN NUMERIC(20,0),
		ReadWriteLSN NUMERIC(20,0),
		BackupSizeInBytes NUMERIC(20,0),
		SourceBlockSize NUMERIC(20,0),
		FileGroupID NUMERIC(20,0),
		LogGroupGUID VARCHAR(50),
		DifferentialBaseLSN NUMERIC(20,0),
		DifferentialBaseGUID VARCHAR(50),
		IsReadOnly NUMERIC(20,0),
		IsPresent NUMERIC(20,0)
	)

	INSERT INTO @FILELIST (LogicalName, PhysicalName, FileType, FileGroupName, FileSize, FileMaxSize,
FileID,
CreateLSN,
DropLSN,
UniqueID,
ReadOnlyLSN,
ReadWriteLSN,
BackupSizeInBytes,
SourceBlockSize,
FileGroupID,
LogGroupGUID,
DifferentialBaseLSN,
DifferentialBaseGUID,
IsReadOnly,
IsPresent

)
		EXEC master.dbo.sqlbackup @sqb_filelistonly_cmd

petey

The data types follow that returned by the native RESTORE FILELISTONLY command. Your LSN columns need to be NUMERIC(25, 0) instead of NUMERIC(20, 0).

cluthy

Thanks, thats what I was missing