Cannot restore SQL Error Code:5133

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Cannot restore SQL Error Code:5133

Postby keymoo » Wed Jun 30, 2010 1:20 pm

Hi there,

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

Code: Select all
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.
keymoo
 
Posts: 27
Joined: Fri Oct 19, 2007 9:22 am

Postby Anu Deshpande » Wed Jun 30, 2010 3:16 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests