Skip to content

Instantly share code, notes, and snippets.

@amalrik

amalrik/restore_filelistonly.sql

Created July 30, 2017 14:42
Show Gist options
  • Save amalrik/c65f8e2d138f098079ea7794459c1f0d to your computer and use it in GitHub Desktop.
Save amalrik/c65f8e2d138f098079ea7794459c1f0d to your computer and use it in GitHub Desktop.
Download ZIP
list files on sqlserver backup
Raw
restore_filelistonly.sql
1> RESTORE FILELISTONLY from DISK = '/var/opt/mssql/backup/usersdb_erp_bc.bak'
2> GO
LogicalName PhysicalName Type FileGroupName Size MaxSize FileId CreateLSN DropLSN UniqueId ReadOnlyLSN ReadWriteLSN BackupSizeInBytes SourceBlockSize FileGroupId LogGroupGUID DifferentialBaseLSN DifferentialBaseGUID IsReadOnly IsPresent TDEThumbprint SnapshotUrl
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---- -------------------------------------------------------------------------------------------------------------------------------- -------------------- -------------------- -------------------- --------------------------- --------------------------- ------------------------------------ --------------------------- --------------------------- -------------------- --------------- ----------- ------------------------------------ --------------------------- ------------------------------------ ---------- --------- ------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
UsersDB_ERP_QL D:\SQL Data\BC\MDF\BookingDB_ERP.mdf D PRIMARY 5537988608 35184372080640 1 0 0 F60D3BB8-B907-4E75-81F6-DF33601D654E 0 0 5537529856 512 1 NULL 47140000000025600021 D61A7247-87FB-470A-89D6-2F19486B24DA 0 1 NULL NULL
UsersDB_ERP_QL_log D:\SQL Data\BC\LDF\BookingDB_ERP.ldf L NULL 12648448 2199023255552 2 0 0 CFD1DEB9-57F0-4AC7-8F5F-A000B3A41E14 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1 NULL NULL
(2 rows affected)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment