Storage Compress

[Bgfreeman]

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.

[eddie davis]

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