Storage Compress

Silent data compression to optimize SQL Server Storage

Storage Compress

Postby Bgfreeman » Fri Feb 04, 2011 11:27 am

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

Named the files mdfx and ldfx

Got this error:


Restoring full backup - Failed

This operation failed with errors.

Restoring tes_community (database) on TSLDBBUILD02 instance from:
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.
Posts: 15
Joined: Fri Apr 23, 2010 5:45 pm

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


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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1150
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Storage Compress Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests