Hyperbac for SQl server

Question

Hyperbac for SQl server

Trooper09

SSCrazy

Points: 2047
More actions
July 23, 2009 at 10:01 am

#134462

Hi,
I am in the process of trying out the tool 'Hyperbac for SQL server' to compress my database backups.
I was wondering if anybody used this tool earlier .
I had few concerns as how the db backup works and how would I restore a zip file to a database when the backup is taken as .zip on the same server.
I did go through the admin guide for Hyperbac and I was not not able to find answers to my questions:
Syntax being used :
to backup the DB :
BACKUP DATABASE tpce
TO DISK = 'B:\backup\HyperBac_Compressed_Backup.ZIP'
WITH INIT
Works , I am able to create the file with the above syntax.
To restore the db :
RESTORE VERIFYONLY
FROM DISK = 'B:\backup\Native_Backup.ZIP'
When I use the above syntax I get the error 'A device attached to the system is not functioning'
Help appreciated.
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Trooper (7/23/2009)
Hi,
I am in the process of trying out the tool 'Hyperbac for SQL server' to compress my database backups.
I was wondering if anybody used this tool earlier .
I had few concerns as how the db backup works and how would I restore a zip file to a database when the backup is taken as .zip on the same server.
I did go through the admin guide for Hyperbac and I was not not able to find answers to my questions:
Syntax being used :
to backup the DB :
BACKUP DATABASE tpce
TO DISK = 'B:\backup\HyperBac_Compressed_Backup.ZIP'
WITH INIT
Works , I am able to create the file with the above syntax.
To restore the db :
RESTORE VERIFYONLY
FROM DISK = 'B:\backup\Native_Backup.ZIP' <-- shouldn't this be 'B:\backup\HyperBac_Compressed_Backup.ZIP' ?
When I use the above syntax I get the error 'A device attached to the system is not functioning'
Help appreciated.
Thanks.

See above note in your quote.

I have HyperBac installed on several production servers for over a year, and I have had no problems with backups and restores.

We are looking at converting one of our undeployed SQL Server licenses to a SharePoint license.

Trooper09 SSCrazy Points: 2047 More actions · Answer 2

I am sorry but even when I give in the correct file location I get the same error message.

I have Hyperbac win extracter and Configuration manager installed , is there anything else that needs to be installed?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Having been using it for over a year without issues, I'm not sure.

Is there anything you may have left out in the steps your are doing?

Trooper09 SSCrazy Points: 2047 More actions · Answer 4

No, Everything went pretty smooth.

Here is the error that I get :

Read on E:\backup.zip failed.'A device attached to the system is not functioning'

verify database is terminating abnormally.

Any clue?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

HyperBac, even though located in Australia, is a very responsive company. At this point I recommend sending them an email detailing the problem you are having. Don't be surprised if you get a phone call in response.

I mention this as I had a minor issue with service applet configuring HyperBac (it did not affect the actual backup/restore process), and they called me several times over the week working with me on identifying the problem.

Trooper09 SSCrazy Points: 2047 More actions · Answer 6

If anybody is in a similar situation , this might help....

I contacted Hyperbac and as Lynn said they got back to me in no time. All I had to do is to install the tool again over the previous installation by logging onto their website . I was told by Hyperbac that this was a known issue and they had a new patch released. Once installed it started working .

Make sure that the version you are using is 4.1.5.0.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Trooper (7/24/2009)
If anybody is in a similar situation , this might help....
I contacted Hyperbac and as Lynn said they got back to me in no time. All I had to do is to install the tool again over the previous installation by logging onto their website . I was told by Hyperbac that this was a known issue and they had a new patch released. Once installed it started working .
Make sure that the version you are using is 4.1.5.0.

Can you give us a quick review of how your backup processes are running in comparision to native backups??