gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertDeze browser wordt niet meer ondersteund.
Upgrade naar Microsoft Edge om te profiteren van de nieuwste functies, beveiligingsupdates en technische ondersteuning.
Applies to:
SQL Server
This topic describes how to view the data and log files in a backup set in SQL Server by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To view the data and log files in a backup set, using:
For information about security, see RESTORE FILELISTONLY (Transact-SQL)
In SQL Server 2008 (10.0.x) and later versions, obtaining information about a backup set or backup device requires CREATE DATABASE permission. For more information, see GRANT Database Permissions (Transact-SQL).
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, and then click Properties, which opens the Database Properties dialog box.
In the Select a Page pane, click Files.
Look in the Database files grid for a list of the data and log files and their properties.
Connect to the Database Engine.
From the Standard bar, click New Query.
Use the RESTORE FILELISTONLY statement. This example returns information about the second backup set (FILE=2
) on the AdventureWorksBackups
backup device.
USE AdventureWorks2022;
RESTORE FILELISTONLY FROM AdventureWorksBackups
WITH FILE=2;
GO
backupfilegroup (Transact-SQL)
backupfile (Transact-SQL)
backupset (Transact-SQL)
backupmediaset (Transact-SQL)
backupmediafamily (Transact-SQL)
Backup Devices (SQL Server)
gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertTraining
Certificering
Microsoft Certified: Azure Database Administrator Associate - Certifications
Beheer een SQL Server-databaseinfrastructuur voor cloud-, on-premises en hybride relationele databases met behulp van de relationele Microsoft PaaS-databaseaanbiedingen.
Documentatie
BACKUP (Transact-SQL) - SQL Server
Back-up (Transact-SQL) maakt een back-up van een SQL-database.