1 Copper

How to restore SQL Server backup

Hi Folks,

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.

Thank you

Tags (2)
0 Kudos