2014 Sql server managment studio not doing what it should be

Question

User-1767698477 posted

I'm trying to restore a .bak file with '14 sql server and '14 management studio.  In the past, this has not been a problem.  Right now I have just installed the program and I'm trying to get my database back so I can use with my program in vs.  I have downloaded a copy of the .bak file and it should be fine. When I create a new database under Object explorer and right click on the database and select tasks->restore->database I select device as the source and click the ellipses and what a minute for my tree to arrive. Then I select the db.  In the past, the program always places it lower down into the white space for "Backup sets to restore" with a checkbox next to it so it can be selected. The program is NOT doing this and this is the reason it won't restore.  Why is this not happening? I need to be able to select it.

Answer 1

User475983607 posted

database I select device as the source and click the ellipses and what a minute for my tree to arrive. Then I select the db

Select the .bak file to restore not the DB file.

Answer 2

User1724605321 posted

Hi sking ,

You can refer to below link for detail steps to restore a Database Backup in Sql Server 2014 Management Studio:

https://docs.microsoft.com/en-us/sql/2014/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-2017&viewFallbackFrom=sql-server-2014 

You can also use T-SQL to restore a backup from a device :

1. Connect to the Database Engine.

2. From the Standard bar, click New Query.

3. In the RESTORE statement, specify a logical or physical backup device to use for the backup operation. This example restores from a disk file that has the physical name Z:\SQLServerBackups\AdventureWorks2012.bak.

RESTORE DATABASE AdventureWorks2012  
   FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak' ;  

Best Regards,

Nan yu

Answer 3

User-236208671 posted

Here is the step-by-step process to restore SQL Server database from .bak file :

https://www.systoolsgroup.com/updates/restore-sql-server-database-from-bak-file/

Answer 4

User-1767698477 posted

I was able to get it resolved. Thanks for your replies here.

https://forums.asp.net/p/2150192/6243582.aspx?p=True&t=636814504532115497