Skip to main content

Ms Sql backup not able to be replicated or restored

Thread needs solution

Hi,

I have a Ms Sql agent backup that runs successfully to a disk location on a Storage Node - (the location contains backup data). However,

1) when I try to replicate the backup (or the location) to tape on the same storage node, it gets a green tick but the log contains, among other associated messages:

   "error 0xa100ab: Failed to get information about the backups"

2) when attempting restore from the disk location on the storage node, the agent on the storage node gives the error:

      "Cannot browse backups of type 'Microsoft SQL Server database' from the selected machine. Please select another machine to browse from."

    and if I use the original source agent, I get no backups to restore.

and, of course, I can't instal a Ms sql agent on the storage node because it has no Ms Sql software on it.

Does anyone know how I can move from successful backups to actually usable backups?

Thanks,

Albert

0 Users found this helpful
frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 22
Comments: 3800

Hi Albert,

There are no such known issues in our bug tracking system, so the problems should be investigated with help from our support team. Make sure to collect system report from Acronis Storage Node (ASN) machine when submitting a ticket: https://kb.acronis.com/content/58301

To localize the 1st problem try backing up to some plain network share, for example to a shared folder on Acronis Storage Node (ASN) machine, instead of current ASN location, and then replicate from this backup to your tape location (ASN-based).

The 2nd issue seems strange and the symptoms are not clear: the browsing of the SQL backups must be done by Agent for SQL, so the first quoted error is expected ("Cannot browse backups of type 'Microsoft SQL Server database' from the selected machine...") when you browse backups by Agent from ASN machine, but it's unclear what happens when you perform browsing from Backups tab using proper agent.

Thank you.

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

Hello Nathan,

as Vasily has mentioned above, such issues should be investigated by Acronis Support Team. We recommend that you open a support ticket and collect Acronis System Report from a machine with Acronis Storage Node (ASN).

Hi Maria,

I have contacted your support team several times since owing your product.

The software is absolute rubbish. Every time there is an issue your support team log's on, does something, it starts working then after a week or so, backup fail again.

I have requested a full refund due to the software being "not fit for purpose" and I will be suing Acronis for lost revenue, wasted time and legal cost should a refund not be supplied.

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

Hello Nathan,

we regret to know about your negative experience with Acronis software and services.

If you do not wish to investigate this issue further, I suggest that you recreate your backup plan with Version 11 backup format which should overcome the problem with AMS database.