How to restore .bak file in SQL Server 2008 R2

Question

I have a code blog but a problem was occurred. In here my backup file is ISBANK.bak and database name is new database name. It doesn't contain anything. I want to add .bak file's content to a new database..

RESTORE DATABASE [DBName]
FROM DISK = 'D:\ISBANK.bak'
WITH REPLACE,
MOVE 'DBName' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008RR2\MSSQL\DATA\DBName.mdf',
MOVE 'DBName' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008RR2\MSSQL\DATA\DBName.ldf'

I am getting these errors:

Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.mdf" failed with the operating system error 3 (failed to retrieve text for this error. Reason: 15105).
Msg 3156, Level 16, State 3, Line 1
File 'OCEAN' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.ldf" failed with the operating system error 3 (failed to retrieve text for this error. Reason: 15105).
Msg 3156, Level 16, State 3, Line 1
File 'OCEAN_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

make sure you select the 'master' database when you run your script. blog.nitorsys.com/restore-sql2008-bak-file-to-local-machine — TheTechGuy
– TheTechGuy, Commented Dec 26, 2012 at 14:16

TheTechGuy · Accepted Answer · 2012-12-26 14:06:23Z

3

Edit

Remove WITH REPLACE

RESTORE DATABASE my_new_database FROM disk = 'E:\path_to_bak_file\database_name_634182143083281212.bak'
WITH
   MOVE 'the logical name from previous operation check row 1' TO 'E:\path_to_sql2008_file_onyour_machine\my_new_database.mdf',
   MOVE 'the logical name from previous operation check row 2' TO 'E:\path_to_sql2008_file_onyour_machine\my_new_database_log.ldf'
GO

You can also use the Restore utility available in SQL Server Management Studio (SSMS). This is a step by step process which lets yous select the .bak file and restore it as new database (which ever name you like for it).

Fire SQL Server Management Studio, connect to the server as admin, right click on the database node and select restore.

enter image description here

edited Dec 26, 2012 at 14:06

answered Dec 26, 2012 at 13:43

TheTechGuy

17.5k18 gold badges120 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

TheTechGuy Over a year ago

remove WITH REPLACE by 'WITH'

Yunus emre Over a year ago

I try to what you said but it didn't work. maybe ı dont have permission. is it possible??

TheTechGuy Over a year ago

@Yunusemre the errors do not seem be related to permissions. Did you run in in master database? Did you remove the comma after with? You m ay also try to export it to a folder where you have full permission such as my documents, just to test it.

Yunus emre Over a year ago

unfortunately occured the same problem

Dinesh vishe · Accepted Answer · 2019-08-19 14:48:17Z

0

you have use default path for database restoration.

This will useful to you.

answered Aug 19, 2019 at 14:48

Dinesh vishe

3,6581 gold badge27 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to restore .bak file in SQL Server 2008 R2

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related