Storage Compress

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, javen

Storage Compress

Postby Bgfreeman » Fri Feb 04, 2011 12:27 pm

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.
Bgfreeman
 
Posts: 15
Joined: Fri Apr 23, 2010 6:45 pm

Postby eddie davis » Thu Feb 24, 2011 4:41 pm

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Storage Compress 5

Who is online

Users browsing this forum: No registered users and 0 guests