Red Gate forums :: View topic - Largest successful restore from .SQB ?? (4TB failed)
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

Largest successful restore from .SQB ?? (4TB failed)

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



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Wed Jul 27, 2011 7:38 pm    Post subject: Largest successful restore from .SQB ?? (4TB failed) Reply with quote

I am looking for data regarding largest successful restore from a .SQB to compressed files (.mdfx, .ndfx, .ldfx)

We are wanting to utilize this tool on our reporting warehouse, but the 4TB database, when backed up to a 589GB backup using compression=1, will not restore properly. I was able to restore to a virtual database using similar technology.

I have ran a full DBCC checkDB against the source.
I am unable to run a normal restore of the database due to disk space.
I was able to complete a restore VERIFYONLY.

At this point I do not suspect the backup file of corruption nor the source database.

Here is the code I run (which includes 22 filegroups) and the error received.
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Reporting01_Compress]
FROM DISK = ''G:\DatabaseBAK\REPORTING01\FULL_(local)_REPORTING01_20110716_060000.sqb''
WITH RECOVERY,
MOVE ''REPORTING01'' TO ''K:\MDF\Reporting01_Compress.MDFX'',
MOVE ''REPORTING01_Log'' TO ''E:\LDF\Reporting01_Compress.LDFX'',
MOVE ''REPORTING01_PKEBC'' TO ''I:\IDF\Reporting01_Compress_PKEBC.NDFX'',
MOVE ''REPORTING01_MrgChargeActive'' TO ''E:\NDF\Reporting01_Compress_MrgChargeActive.NDFX'',
MOVE ''REPORTING01_ChargeActive'' TO ''I:\NDF\Reporting01_Compress_ChargeActive.NDFX'',
MOVE ''REPORTING01_LogTapeCharge_Indexes'' TO ''K:\IDF\Reporting01_Compress_LogTapeCharge_Indexes.NDFX'',
MOVE ''REPORTING01_Transactions'' TO ''J:\NDF\Reporting01_Compress_Transactions.NDFX'',
MOVE ''REPORTING01_TapeTempDemo'' TO ''J:\NDF\Reporting01_Compress_TapeTempDemo.NDFX'',
MOVE ''REPORTING01_ChargeAudit'' TO ''J:\NDF\Reporting01_Compress_ChargeAudit.NDFX'',
MOVE ''REPORTING01_RemitPostBatches'' TO ''J:\NDF\Reporting01_Compress_RemitPostBatches.NDFX'',
MOVE ''REPORTING01_LogChargeActive'' TO ''J:\NDF\Reporting01_Compress_LogChargeActive.NDFX'',
MOVE ''REPORTING01_LogInsuranceProfile'' TO ''J:\NDF\Reporting01_Compress_LogInsuranceProfile.NDFX'',
MOVE ''REPORTING01_LogWorkfileUserActivity'' TO ''K:\NDF\Reporting01_Compress_LogWorkfileUserActivity.NDFX'',
MOVE ''REPORTING01_PKDS'' TO ''J:\IDF\Reporting01_Compress_PKDS.NDFX'',
MOVE ''REPORTING01_LogTapeCharge'' TO ''I:\NDF\Reporting01_Compress_LogTapeCharge.NDFX'',
MOVE ''REPORTING01_ClaimLog'' TO ''I:\NDF\Reporting01_Compress_ClaimLog.NDFX'',
MOVE ''REPORTING01_Indexes01'' TO ''K:\IDF\Reporting01_Compress_Indexes01.NDFX'',
MOVE ''REPORTING01_ChargeAudit_Indexes'' TO ''K:\IDF\Reporting01_Compress_ChargeAudit_Indexes.NDFX'',
MOVE ''REPORTING01_LogChargeActive_Indexes'' TO ''K:\IDF\Reporting01_Compress_LogChargeActive_Indexes.NDFX'',
MOVE ''REPORTING01_ChargeActive_Indexes'' TO ''J:\IDF\Reporting01_Compress_ChargeActive_Indexes03.NDFX'',
MOVE ''REPORTING01_Transactions_Indexes'' TO ''J:\IDF\Reporting01_Compress_Transactions_Indexes.NDFX'',
MOVE ''REPORTING01_MrgTables'' TO ''E:\NDF\Reporting01_Compress_MrgTables.NDFX''"'


ERROR
Msg 5171, Level 16, State 2, Line 1
J:\NDF\Reporting01_Compress_RemitPostBatches.NDFX is not a primary database file.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Thu Jul 28, 2011 8:54 pm    Post subject: Will update SQL Backup from 6.3.0.48 to 6.5.1 Reply with quote

It looks like this server is still on 6.3.0.48. The latest available version of SQL Backup is 6.5.1.
I'm going to update and see if that is any assistance. My other servers are on 6.4.0.56
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Fri Jul 29, 2011 8:26 pm    Post subject: Error 5171 changed related file Reply with quote

After upgrading SQL Backup, the only change is that the error 5171 now references a different file.
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Mon Aug 01, 2011 11:58 am    Post subject: Reply with quote

Thank you for your posts into the forum and sorry that you are encountering a problem.

A support call has been created for this problem, the call reference number is F0050646.

Can you please send to support@red-gate.com the following files:


    Copy of the SQL backup Activity Log file for the restore. (Right click the entry in the SQL Backup GUI and select show log).
    Copy of the HyperBac Service.log file.
    Copy of the HyperBac error log files.
    Copy of the HyperBac status.dat file.
    Copy of the HyperBac configuration file.
    Copy of the HyperBac openstatus.dat file.


You will find the HyperBac service.log and if generated error log files in the \Red Gate\HyperBac\logs folder.

You will find the HyperBac status.dat, hyperbac.conf and openstatus.dat files in the \Red Gate\HyperBac\bin folder.

Please include the Call reference number above in the subject field of your e-mail.

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
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Mon Aug 01, 2011 2:11 pm    Post subject: Processed as script from SSMS not Redgate GUI Reply with quote

I forwarded the requested files short of the restore log. The request assumed I was utilizing the wizard(and the window was still open). I know they use a hidden database, hopefully this file is local.
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Mon Aug 01, 2011 4:23 pm    Post subject: log indicates I failed to update server components Reply with quote

The log (which is located)
Code:
C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\(local)

Shows that the backup was performed as v.6.3.0.48.

I missed updating the server components manually.
I will now try creating another backup file.

My backup takes about 6 hours :(
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Wed Aug 03, 2011 1:51 pm    Post subject: Success after server components update Reply with quote

For the latest restore attempt, I adjusted some file locations in the 'MOVE TO' segment of the restore. Combined with the latest server components for SQL Backup, this was a success !

Now on to load testing.

(Note: I only found that I missed the server components because support requested a log file. When I previewed it, I immediately saw the 6.3 )
Back to top
View user's profile Send private message
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