RESTORE database error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

RESTORE database error

Author

Topic

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-03-18 : 03:00:35

hello everybody,
could anybody give me solution for this problem.
when i try to restore database or restore filelist i get this error
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'E:\MSSQL\Backup\AdventureWorks\ AdventureWorks_20110318110001.BAK'. Operating system error 2(failed to retrieve text for this error. Reason: 15100).
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-18 : 13:01:58

You seem to have an extra space in your file name. Remove the space and try again.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2011-03-18 : 13:43:21

D'oh

Is the E drive a local drive also?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-03-19 : 10:42:54

quote:
Originally posted by X002548

D'oh

Is the E drive a local drive also?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

yes,it is a local drive

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-19 : 16:38:48

Did you try removing the space?

Local drive or not, doesn't matter for your error.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-03-20 : 03:05:56

quote:
Originally posted by tkizer

Did you try removing the space?

Local drive or not, doesn't matter for your error.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

are you speaking about the space before backup file name?
are u speaking about the space before backup file name?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-20 : 03:51:45

Yes. That space should not be there.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-03-21 : 01:26:33

quote:
Originally posted by tkizer

Yes. That space should not be there.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

thanks a lot tara...as i removed the space it worked right...
thank you very much

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-21 : 12:50:23

You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources