Restore fails, '5(Access is denied.) under admin rights

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

Restore fails, '5(Access is denied.) under admin rights

Postby jlange » Fri Sep 24, 2010 6:10 pm

I'm using the wizard to select the hyperbac compressed file and restore it to the existing directory, with the username on the machine being both a local admin and having dbo in SQL Server. I keep running into the following error when the wizard attempts to restore the database:
The operation system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on <filepath>.

I've verfied that the target location exists and checked that the sql service is running as local system. Any other areas to check? Thanks.
jlange
 
Posts: 2
Joined: Fri Sep 24, 2010 5:43 pm

Postby javen » Fri Sep 24, 2010 11:03 pm

If the backup file is remote to the system you are doing a virtual restore on, then you need to change the HyperBac service account to an account which has full control access to the remote path (eg domain user account). This is the only time you would change the HyperBac service from running as LocalSystem.
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am

Postby jlange » Sat Sep 25, 2010 6:47 pm

The backup file isn't on a remote system, and is located on the same volume where hyperbac made the backup. Is there a internal account hyperbac might be using to perform the restore? Otherwise I'm totally out of ideas. I'm having this problem on another server as well. I'm running windows 2003 enterprise x64 if that helps to bring up any ideas. Thanks.
jlange
 
Posts: 2
Joined: Fri Sep 24, 2010 5:43 pm

Postby eddie davis » Tue Sep 28, 2010 5:16 pm

Hi

I have just sent a private message to you. I need to create a Support Call for you, as per the private message I sent, can you please send an e-mail to support@red-gate.com with the requested information.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests