@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
SQL Server “RESTORE FILELISTONLY” Resultset
标签:column fine ini strong logical rom restore nbsp ports