How do I list the database files contained in a SQL Server 2005 backup file using T-SQL?
For instance:
The restore process will create:
bob.mdf
bob.ldf
etc…
Sql-server – How to list the database files contained in a SQL Server 2005 backup file using T-SQL
restoresql serversql-server-2005
Related Question
- Sql-server – How to restore SQL Server database to a custom location, if the backup file was renamed
- Sql-server – Restoring differential backup from SQL Server 2005 to SQL Server 2012
- Sql-server – Restoring corrupt SQL Server 2005 database
- Sql-server – Restoring a SQL Server 2008 R2 backup on SQL Server 2005
- Sql-server – How to restore Network backup to Network Path in SQL Server 2005
- Sql-server – Backup the whole SQL Server databases in one .bak file – SQL Server 2005
- Sql-server – SQL Server – SQL script to restore database backup file into a new database
Best Answer
RESTORE FILELISTONLY