Answered by:
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.
Sunday, October 14, 2018 11:17 PM
Answers
-
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
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, December 27, 2018 3:48 AM
All replies
-
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 dbSelect the .bak file to restore not the DB file.
Monday, October 15, 2018 10:34 AM -
User1724605321 posted
Hi sking ,
You can refer to below link for detail steps to restore a Database Backup in Sql Server 2014 Management Studio:
You can also use T-SQL to restore a backup from a device :
-
Connect to the Database Engine.
-
From the Standard bar, click New Query.
-
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
Tuesday, October 16, 2018 2:04 AM -
-
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/
Saturday, October 20, 2018 7:14 AM -
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
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, December 27, 2018 3:48 AM