SQL database restore not working

Question

Hi,

I'm trying to a backup of a database calles WSS_Content_Base to a database of the same name on a different server.

When I try restore the database through SSMS I get the attached error:

When I then tried to run the backup with the below SQL:

RESTORE DATABASE WSS_Content_Base 
	FROM DISK = 'E:\WSS_Content_Base_20130917.bak'

I got this error:

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'E:\WSS_Content_Base_20130917.bak'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Can anybody please advise what the issue might be?

Oh, by the way the original database has the data in D:\Data\WSS_Content_Base.mdf and the log in D:\Logs\WSS_Content_Base_Log.ldf but on the new server I only have a c:\ and E:\ drive. I would like both files to go to E:\. I'm not sure if this has any impact on the restore.

Cheers

Paul

Answer 1

but on the new server I only have a c:\ and E:\ drive. I would like both files to go to E:\.

Hello Paul,

Then you have to use the MOVE option for the restore command to locate the database in a different drive/folder.

Is the backup file really located on drive E: on the server where you want to restore the backup file? Is E: a local drive or a mapped network share?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

1) Make sure that you typed correct path to the BAK file

2) Make sure that account you run the RESTORE statement has permission to read drive E:\

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 3

You may have to use the WITH move options or set the file paths (mdf & ldf) in SSMS restore window

---

Satheesh
My Blog