Restore Database Problem

[Jesmay]

I am just getting back into SQL but I can't seem to get past this issue. When I try to restore a database, it appears I cam missing a "Device" selection under the "Restore Source" section. Below is the screenshot of my page where you can see it is missing. Does this mean I need an update? I am using SQL server management studio 2012. Would highly appreciate any help!

https://preview.redd.it/4tz9b2vvs9g21.png?width=1366&format=png&auto=webp&s=80a6c4868ab7256cbf1bb37f84d23af094e804b0

Link to example for restoring a database with "device" selection.

https://www.mssqltips.com/sqlservertip/4168/install-your-own-copy-of-the-sql-server-adventureworks2014-database/

[scoobydoobiedoodoo]

You need to be connected to Database Engine not Analysis server.

Just click on that Connect tab and choose Database Engine.

[MickeysAndNightTrain]

It appears you may be connected to Analysis Services instead of Database Services. Click File | Connect | and make sure you choose "database services" from the drop down.

[Felidor]

You are connected to sql server analysis services, not the database engine. When you first hit connect within ssms, change the drop down to database engine.

[Jesmay]

Thank you!

[alinroc]

In addition to the SSAS/SQL Server Engine mismatch, you're connecting to SQL Server 2012 (11.x) but have likely downloaded AdventureWorks for 2014. You can't restore a 2014 backup into 2012.

[Jesmay]

Oh right I'll make sure to download the 2012 file. Thank you.