|
|
| Definitions More Info. | | Definition ID | 970 | | Title | SQL | | Category | NOTES | | Definition | RESORE FILELISTONLY insert into a table | | Definition Description | https://stackoverflow.com/questions/2511502/sql-server-restore-filelistonly-resultset
-- Backup dosyasi içindeki data dosyalarinin, adlari ile birlikte dizinlerini listeler
DECLARE @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
[SnapshotURL] NVARCHAR(360)
)
INSERT INTO @fileListTable EXEC('RESTORE FILELISTONLY FROM DISK = ''I:\Backup\AtlantisDB_20190829_000103.bak'';')
SELECT * FROM @fileListTable | | RecordBy | cunay | | Record Date | 30-08-2019 21:57:48 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|