SQL Server “RESTORE FILELISTONLY” Resultset

@fileListTable TABLE ( [LogicalName] NVARCHAR(128), [PhysicalName] NVARCHAR(260), [Type] CHAR(1), [FileGroupName] NVARCHAR(128), [Size] NUMERIC(20,0), [MaxSize] NUMERIC(20,0), [FileID] BIGINT, [CreateLSN] NUMERIC(25,0), [DropLSN] NUMERIC(25,0), [UniqueID] UNIQUEIDENTIFIER, [ReadOnlyLSN] NUMERIC(25,0), [ReadWriteLSN] NUMERIC(25,0), [BackupSizeInBytes] BIGINT, [SourceBlockSize] INT, [FileGroupID] INT, [LogGroupGUID] UNIQUEIDENTIFIER, [DifferentialBaseLSN] NUMERIC(25,0), [DifferentialBaseGUID] UNIQUEIDENTIFIER, [IsReadOnly] BIT, [IsPresent] BIT, [TDEThumbprint] VARBINARY(32) -- remove this column if using SQL 2005 ) INSERT INTO @fileListTable EXEC(‘RESTORE FILELISTONLY FROM DISK = ‘‘YourBackupFile.bak‘‘‘) SELECT * FROM @fileListTable After SQL Server 2012 going to need to add a new column, SnapshotURL nvarchar(360), e.g. as per msdn.microsoft.com/en-us/library/ms173778.aspx, but I am unsure whether that is for SQL Server 2014 or 2016 (I think it starts in 2016...) – JonBrave Aug 25 ‘16 at 14:23

 

SQL Server “RESTORE FILELISTONLY” Resultset

标签：column   fine   ini   strong   logical   rom   restore   nbsp   ports