Last post Dec 27, 2018 03:48 AM by sking
Oct 14, 2018 11:17 PM|sking|LINK
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.
Oct 15, 2018 10:34 AM|mgebhard|LINK
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.
Oct 16, 2018 02:04 AM|Nan Yu|LINK
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' ;
Oct 20, 2018 07:14 AM|JohnsonWelch|LINK
Here is the step-by-step process to restore SQL Server database from .bak file :
Dec 27, 2018 03:48 AM|sking|LINK
I was able to get it resolved. Thanks for your replies here.