I'm trying to restore the database. The customer uploaded a .bak file for me, but every time I try to restore the database, I get this error:
Logical file 'master' is not part of database 'my_db'.
Use RESTORE FILELISTONLY to list the logical file names.
I tried these commands
RESTORE FILELISTONLY
FROM DISK = 'D:\Microsoft SQL Server\MSSQL12.\MSSQL\Backup\xxx_backup.BAK'
Result is master and mastlog.
What I had when I wanted to restore the db, I still get the error message logical file 'master' is not part of database name.
Guys please help me.
Actually, I'm only concerned with one specific database that contains essential data for me
This is a backup that has multiple backupsets on the media. Is there a way to restore only one specific one? The .bak file contains a backup of all db per instance, which is approximately eight databases.