Red Gate forums :: View topic - Restore of database too large for the volume
Return to www.red-gate.com RSS Feed Available

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

Restore of database too large for the volume

Search in SQL HyperBac 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cschwinge



Joined: 26 Jan 2010
Posts: 2

PostPosted: Wed Jun 22, 2011 3:17 pm    Post subject: Restore of database too large for the volume Reply with quote

Hello,

I'm trying to restore a database that is too large for the volume, and am getting an error:

Msg 3257, Level 16, State 0, Line 1
There is insufficient free space on disk volume 'I:\' to create the database. The database requires 225443840000 additional free bytes, while only 161451290624 bytes are available.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

After reasing the forums, I tried using the following line to the hyperbac.conf file and restarting the Hyperbac control service, but I get the same error.

VirtualDiskSize=325

Using windows 2000, sql server 2000 (8.00.2039). I even upgraded Hyperbac to the latest available version, so I've had this problem in 5.0.22 and in 5.2.9

When this compressed database was created, it was not too large for the volume, so I don't know if this has ever worked.

Any ideas?

Thanks in advance
-Claus
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Thu Jun 23, 2011 8:30 pm    Post subject: Reply with quote

Thank you for your post into the forum.

Are you restoring this backup file to overwrite an existing database? Or creating a new database?

The fact that you are restoring from a compressed backup file, the data held in the backup file is uncompressed as it is written to the disk to restore the database.

Basically you do not have sufficient free disk space to complete the restore process.

The VirtualDiskSize parameter which can be added to the config file will only help if you are restoring the backup file to create a virtual database using SQL Virtual Restore or compressed database using SQL Storage Compress. As the parameter is used to fool SQL Server into believing there is sufficient disk to complete the restore.

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
cschwinge



Joined: 26 Jan 2010
Posts: 2

PostPosted: Fri Jun 24, 2011 2:37 pm    Post subject: Reply with quote

I am using Storage Compress, and restoring to a new database using the command:

restore database TST_FA_H3
from disk = 'X:\MSSQL\SQL2KDEV1\SQL_BAK_FILES\TST_FA_H3_BAK.hbc'
WITH MOVE 'TST_FA_H3_Data' TO 'I:\MSSQL\SQL2KDEV1\SQL_DAT_FILES\TST_FA_H3_data.mdfx',
MOVE 'TST_FA_H3_Log' TO 'X:\MSSQL\SQL2KDEV1\SQL_LOG_FILES\TST_FA_H3_Log.ldfx'

In the Hyperbac Configuration Manager - Extensions tab I can see the the mdfx and ldfx extensions are enabled and online. Also in the Status tab I can see the VirtualDiskSize=325 change
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