@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
查看更多关于SQL Server “RESTORE FILELISTONLY” Resultset的详细内容...