I have taken a backup from a PC has localhost server with Windows authentication, and I want to restore this backup to another PC which has a localhost server with Windows authentication.
I tried to restore it from SQL Server Management Studio, but it does not appear like other.bak files I mean when you choose a backup file to restore all files with (.bak) extension will appear and as I noticed only backup files who created by the same PC will appear, as I know this problem is because a connection string is different from the first PC to the second PC.
Is there any way to restore it?
And I don't want to make a script file, I need it as a backup file. anyone help please.