Automatically import .bak file on a daily basis I have a piece of industrial equipment running SQL Server with a database named, let's say, &quot;primary&quot;. The equipment creates on a daily basis a .bak file (of the full database) and it transfers it to a server running SQL Server. On the server, I need to have an ARCHIVE of &quot;primary&quot;.
My idea is to create a daily job to import only the new records from the .bak file, but I have no idea where to start from.
I have looked online for &quot;importing .bak into SQL Server&quot; but all I find is about the RESTORE command which I'm afraid doesn't work in my case.
Can anyone point me in the right direction?
UPDATE 1 - According to the warranty given to us by the manufacturer of the equipment, we can't interact in any way with the embedded SQL Server. The only way to access the data is via the .bak file.
backup files (BAK files) can't be read to take only some records inside. You can only restore them. Then you can import from the restored database what you like.