Unable to restore data because of an unknown error.

(0) Share

Report

Posted on by Community Member

Hello,

Please I need help.

I want to restore a back up but its giving me unknown error.

Most of the time I get this error what I do is to restart the system or relocate the backup file and it worked. but this time around no luck what can I do?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

soma 24,410 on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

Did you get any error message? Please attach the screenshot for the error message.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

Thanks for your response.

The error I get is "unknown error".

I could paste the screen shot you would have seen it.

Thank you

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

Please try the suggestions from the below link.

groups.google.com/forum

Note:

1. Make sure the SQL instance accepting remote connections, TCP/IP protocol is enabled for this instance and that Windows Firewall is set up to allow connections to TCP/IP port that it uses.

2. If database mirroring is set up, remove it prior to restore.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

Tom Mathew 1,750 on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

1. Do you have write permission to the folder.

2. Space is there in the drive.

3. Was the backup taken without any error..make sure the .bak file is not corrupted

Try running the sql service using a local account instead of the network service and then perform the restore.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

First thing I would make sure is that you are not in the company (assuming you are doing this from within GP) that you are trying to restore. Otherwise a Dexsql.log may give us more information as to what is causing the issue.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

Check the error log in SQL. It will tell you why the restore is failing. The most common issue is out of space.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

@Richard

Find below the error I found in DEXSQL.

(restore database WACHQ FROM DISK = 'C:\Users\Solomon\Documents\BACKUP\WACHQ_June4-2014B.bak'

/*

/* Date: 06/04/2014 Time: 18:00:05

SQLSTATE:(37000) Native Err:(3101) stmt(11918160):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Exclusive access could not be obtained because the database is in use.*/

/*

/* Date: 06/04/2014 Time: 18:00:05

SQLSTATE:(37000) Native Err:(3013) stmt(11918160):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]RESTORE DATABASE is terminating abnormally.*/)

Please how do I resolve this error.

Thank you

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

FUNMILAYO,

You can't restore the database while the GP application is in running/using. So, request you to log off all the users from dynamics GP and run the below query then restore the database.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

Ok ill try it out thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to restore data because of an unknown error.

@Soma

I did ran all the script yet it repeated the same error.

Please what else can I do?

Thank you

Was this reply helpful? Yes No