Unknown error when attempting to restore

(0) Share

Report

Posted on by Donia Strand

460

We have Dynamics 2010 R2. I can backup a company (affects all companies) with no issues from within Dynamics's Maintenance menu. When I go to restore, I get an "Unknown Error" thrown from Dynamics. (I am on the server and logged in as a Dynamics Admin.) There is no error in the SQL Logs, the Application log, or the System log to go along with this error. I can restore using SQL but does anyone know how I can follow down this error? Has anyone seen it before? Thanks!

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Vincent O. 100 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure but are you certain that there are no other users logged into the company that you are trying to restore to?

Was this reply helpful? Yes No
Donia Strand 460 on at

Like (0)

Report
Copy link

Link copied!

No users were logged in--and all companies affected. Good thought though. I verified no users were in before we ever started the restores.

Was this reply helpful? Yes No
Vincent O. 100 on at

Like (0)

Report
Copy link

Link copied!

What user are you using? I read that you said you are using a Dynamics Admin user... but I am not sure if it is the "sa" user or not. If not, does the same issue happen when using the sa user?

Was this reply helpful? Yes No
Donia Strand 460 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is the SA user. And, I can backup from that same menu, just cannot restore.

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

Like (0)

Report
Copy link

Link copied!

I would run SQL Profiler when you attempt the next restore and hopefully it will give you an idea of what the issue is.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Donia,

I have to ask. Were you logged in to the company you are trying to restore? Can you do a screen shot of the error message and post it? Is there a 'more info' button or a scroll down?

If you run the DYNSQL log does it reveal anything?

Kind regards,

Leslie

Was this reply helpful? Yes No
Donia Strand 460 on at

Like (0)

Report
Copy link

Link copied!

Hi, it mysteriously started working this morning. I was very sure we weren't logged into the company we were trying to restore (we tried to restore multiple companies, so that wouldn't have thrown that error for all of them anyway) We did this over three days with the same error thrown from all companies. The error message had said "Unknown error," no scrolls or more information.

Nothing logged in SQL or Windows. I've never run a DYNSQL log, I'll have to look that up to find out how to do it. Thanks for your help!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The first thing to do is put the database in single user mode. You can do this by right clicking the database in SQL and selecting properties...somewhere in here you can select single user.

Then try and restore again.

Afterwards, don't forget to change the setting back to multi user mode.

Let us know if this resolves (usually though SQL will tell you if there are other connections)

Ian.

Was this reply helpful? Yes No
Donia Strand 460 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Ian. We had no problems restoring from SQL, it was the restore from within Dynamics that wasn't working. Did you mean put the DB in Single User mode and then restore within Dynamics?

Was this reply helpful? Yes No
Jonathan Fear Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This will be removed in future releases Donia. I would get familiar with restoring a backing up databases in SQL.

Was this reply helpful? Yes No