Red Gate forums :: View topic - Cannot restore SQL Error Code:5133
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Backup Previous Versions
SQL Backup Previous Versions forum

Cannot restore SQL Error Code:5133

 Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
keymoo



Joined: 19 Oct 2007
Posts: 27
PostPosted: Wed Jun 30, 2010 1:20 pm    Post subject: Cannot restore SQL Error Code:5133 Reply with quote
Hi there,

I'm trying to restore a database and I get this output from the GUI:

Code:
TPFADBMOPS04\MIPFAPSQLFA01: Restore - Failed
============================================

Restoring full backup - Failed
------------------------------

This operation failed with errors.

Restoring TPOCore_INTB (database) on MIPFAPSQLFA01 instance from:
\\ppfainbaks01\SQLAdHocBackups\Mark\TPO\TPOCore_INTB.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3119: SQL error 3119: Problems were identified while planning for the RESTORE statement. Previous messages provide details.
SQL error 3156: SQL error 3156: File 'TPOCore' cannot be restored to 'D:\MSSQL.3\MSSQL\Data\TPOCore_INTB_TPOCore.mdf'. Use WITH MOVE to identify a valid location for the file.
SQL error 5133: SQL error 5133: Directory lookup for the file "D:\MSSQL.3\MSSQL\Data\TPOCore_INTB_TPOCore.mdf" failed with the operating system error 5(error not found).
SQL Backup exit code: 1100
SQL error code: 5133


Any ideas - i know that os system error 5 means Access Denied - what is access denied? The sql backup service account is a sysadmin in SQL Server and a local admin on the server.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
PostPosted: Wed Jun 30, 2010 3:16 pm    Post subject: Reply with quote
I suspect from the error message in the SQL Backup Log File, that you have provided the incorrect paths for the mdf and ldf file locations for the database you are trying to restore into. From the information you have provided you are restoring the backup file into a database called TPOCore_INTB if restoring using the Restore Wizard, at Step 3 you need to check the option to restore over existing database and click on the Database Files button. Ensure that the Phyiscal file name for the mdf and ldf files is correct.

Kindly let me know if the above suggestion helped.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group