I need to work with a SQL server instance, however my workspace runs Linux and the database backup that was given to me was running on Windows.
I succesfully managed to install SQL Server on my Linux environment, and I'm using DBeaver to access it, the main problem I have is when I try to restore this .bkp file in my SQL Server instance.
I'm trying to restore the database with this SQL command I read in an answer in this site, however I need the Logical Data File Name and the Logical Data Log. So I ran the next SQL command.
RESTORE DATABASE FILELISTONLY
FROM DISK = '/var/tmp/(redacted).bkp';
I get SQL Error 5133
SQL Error [S0001]: Directory lookup for the file "D:\SQL2012\DATA\(redacted).mdf" failed with the operating system error 2(The system cannot find the file specified.).
Is it possible to restore this file? If so what am I doing wrong?
Thanks in advance.