Backup message: Unknown error

(0) Share

Report

Posted on by Gilberto Villegas

225

Hi there,

I am trying to run a database backup from the Maintenance menu in GP 10.0.
The module let me to create a backup schedule, but when I try to run an immediate backup, "Unknown error" comes out and nothing happen. Similar situation I got attempting a system database backup.

This is a fresh installation with GP10 1319 version running under SQL 2008 SP2.
With all users logged out it shows up same error message.

Thank you in advance for your help

Gilberto Villegas
IT Plus Inc.
GP Business Solutions Partner

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

MG-16101311-0 26,225 on at

Like (0)

Report

Do you have enough permissions on the directory you are attempting to backup to? I tried a few scenarios and was not able to replicate this issue. I am also on the same build number and SQL Server 2008 with SP2.

Was this reply helpful? Yes No
Gilberto Villegas 225 on at

Like (0)

Report

Mariano,

I am using Terminal Services and I am logged as Administrator user.

Thank you

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

Do you have the SQL directory under your GP installation on TS?

Was this reply helpful? Yes No
Gilberto Villegas 225 on at

Like (0)

Report

No, they are in different paths.

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

On the GP server client, there is usually a folder under your GP installation called SQL. If this directory is not present, you may receive the error you are reporting. Try backing up the data from the GP server itself. If this works, then you are missing the SQL folder under your GP installation folder on your TS. You can whether this is something you want to do for your TS environment as copying this folder would add server capabilities to this environment.

Was this reply helpful? Yes No
Gilberto Villegas 225 on at

Like (1)

Report

There is a SQL folder under GP directory. This is the complete path:

E:\Program Files(x86)\Microsoft Dynamics\GP\SQL.

This is a 64bit machine.

By default the backup program points to the next location to keep the jobs:

E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup

I just found out that in this location I get the "Unknown error" every time I attempt to make an immediate backup and

in other location (in databases partition) the backup is succesful.

Thank you for your support

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

Do you get the same error when you attempt to backup from SQL Server Management Studio to that location?

Was this reply helpful? Yes No
Gilberto Villegas 225 on at

Like (0)

Report

From SQL Server Management Studio I am not getting any error backing up to that location.

Was this reply helpful? Yes No
GovindDevda 617 on at

Like (0)

Report

Hey thanks to Gilberto & Mariano i have also occurred this type of error and i just change the path E:/ABCPO.bak and resolve the problem. Great Job thanks for Support !!

Thanks !

Govind Devda

Was this reply helpful? Yes No
Suggested answer

coquisalsa 2,725 on at

Like (0)

Report

Hola Gilberto,

Perhaps a silly question, but worthy for clarification, are you log as 'sa'?

Thanks

Jorge

Was this reply helpful? Yes No