Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Backup message: Unknown error

Posted on by 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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Backup message: Unknown error

    Hi,

    I realize this is an old post, but fyi, Dynamics is incorrectly defaulting to backing up to "..\Program Files\whatever" . That won't work due to Windows security.

    Instead, manually edit the path to reflect "..\ProgramData\whatever" (note there's no space between Program and data). That will work. In GP v10, a simple and fast to type path I liked to use was "C:\ProgramData\MBS\DYNGP\Backup\<yourDBname>\".

    Likewise, you could select any other path (except "..\Program Files\whatever") where you have sufficient permissions and it should work as well.

    Regards . . .

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Backup message: Unknown error

    Hola Gilberto,

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

    Thanks

    Jorge

  • GovindDevda Profile Picture
    GovindDevda 615 on at
    RE: Backup message: Unknown error

    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

  • Gilberto Villegas Profile Picture
    Gilberto Villegas 225 on at
    Re: Re: Re: Re: Re: Re: Re: Re: Backup message: Unknown error

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

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: Re: Re: Backup message: Unknown error

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

  • Gilberto Villegas Profile Picture
    Gilberto Villegas 225 on at
    Re: Re: Re: Re: Re: Re: Backup message: Unknown error

    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 

     

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: Backup message: Unknown error

    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.

  • Gilberto Villegas Profile Picture
    Gilberto Villegas 225 on at
    Re: Re: Re: Re: Backup message: Unknown error

    No, they are in different paths.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Backup message: Unknown error

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

  • Gilberto Villegas Profile Picture
    Gilberto Villegas 225 on at
    Re: Re: Backup message: Unknown error

    Mariano,

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

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans