Unknown error while trying to restore

(0) Share

Report

Posted on by br4ndonn4bors

We're trying to restore to a company listed in the GP company list. I'm logged in as SA and using a different company. I can backup with no errors. But when I try to restore, I get "Unknown Error". Any suggestions how to correct this?

*This post is locked for comments

All responses (4)

Answers (0)

Jonathan Fear on at

Like (0)

Report

Re: Unknown error while trying to restore

This issue is probably because you are logged into GP as restoring the company. I would recommend you use SQL Management Studio. Also the Windows user that is running the SQL instance probably is local service account which does not have the permissions that are needed to restore databases. I have switched this account to a domain account which resolved this issue.
L Vail 65,271 on at

Like (0)

Report

Re: Unknown error while trying to restore

Yes,

When you restore from Management Studio, be sure to hit the options tab and force the overwrite of the existing database.

This may seem silly, but don't forget to backup the database before you do the restore.

Kind regards,

Leslie
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Unknown error while trying to restore

Are you restoring from within GP?, if so, make sure there are no other users in the system, but I will recommend you restore from using SQL Management Studio as you can control overwriting current database files as well validate that the restore is actually pointing to the correct files.
L Vail 65,271 on at

Like (0)

Report

Re: Unknown error while trying to restore

Can you run the restore from Studio Manager?