Red Gate forums :: View topic - Storage Compress
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Storage Compress 5
SQL Storage Compress 5 forum

Storage Compress

Search in SQL Storage Compress 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Bgfreeman



Joined: 23 Apr 2010
Posts: 15

PostPosted: Fri Feb 04, 2011 12:27 pm    Post subject: Storage Compress Reply with quote

I just tried to restore a 200Gb database using Storage Compress 5.

Named the files mdfx and ldfx

Got this error:

TSLSQBUILD01V\TSLDBBUILD02: Restore - Failed
============================================

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

This operation failed with errors.

Restoring tes_community (database) on TSLDBBUILD02 instance from:
W:\ForRestore\FULL_TSLDBPR102_TES_Community_20110201_154737.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 5171: SQL error 5171: U:\MSSQLDATA\tes_community.mdfx is not a primary database file.
SQL Backup exit code: 1100
SQL error code: 5171



Updating SQL Server information - Pending
-----------------------------------------

Operation pending.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Thu Feb 24, 2011 4:41 pm    Post subject: Reply with quote

Hi

Sorry for the delay in replying back to you.

The problem you are experiencing I believe is a SQL Error and not neccesary SQL Backup or SQL Storage Compress problem.

SQL Error 5171, in my experience, occurs when attaching a database file and the database file header is corrupt or invalid information is in the header.

Are you able to perform a normal restore using the SQL Backup file .sqb, not using SQL Storage Compress?

What syntax are you using to perform the SQL Storage Compress restore?

Do you have available another SQL Backup .sqb file you can use for test purposes and attempt a Storage Compress restore on this backup file?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate 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