What are the challenges you face when working across database platforms? Take the survey
Options

Proper data types from sb 5.2 "RESTORE FILELISTONLY"

cluthycluthy Posts: 8
edited October 9, 2007 7:03PM in SQL Backup Previous Versions
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

Comments

Sign In or Register to comment.