MemberDecember 5, 2020 at 2:13 pm
Follow these steps to restore the backup file into server
Open the link
Download AdventureWorks2017 under OLTP in that website
Copy the .bak file which we downloaded earlier.And paste it on the respective path
C:\Program Files\Microsoft SQL Server\MSSQL 15.MSSQLSERVER\MSSQL\Backup
Paste at this path
Open the SSMS
Right click on databases and click on Restore databases then Restore database window will appear
In that window,
Under source section select Device,then you find 3 dots box.
Click on that box.
You will get select backup devices window
In that window click Add then it will direct to locatebackupfile window of contents of PC,then we have to select the downloaded file which we paste on the above mentioned path.
And then press OK
That locatebackupfile window will be closed and again press OK
Backupdevices window will also be closed
Put tick mark at the restore box and then tap OK in the restore database window.
Then the file will be restored into the server successfully…..🙂
If you face any issues or have any doubts,ping me😊
Log in to reply.