好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

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   

查看更多关于SQL Server “RESTORE FILELISTONLY” Resultset的详细内容...

  阅读:22次