SQL 2008 R2

leop1212
leop1212 used Ask the Experts™
on
SQL 2008 R2 std server.
 I moved few databases from Drive F: to Drive E:
by taking DB off line, dropping and attaching.
I am not able to reattached two DB. see error attached
I am not able to restore it from the backup (backupexec sQl option to original location  either
(Server: "BACKUPEXEC14") (Job: dbrestore")  -- The job failed with the following error: A failure occurred restoring because the files cannot be replaced and no alternate location was specified.
 any ideas?
sqlerr.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
Hi,

There are two things I think you can try to resolve this problem.

1, log into SQL Server Management Studio and try again.

OR

Navigate to the data folder called IONDATA I think, right-click on that folder and temporarily edit Security to add Everyone and give it full control permission and try again.

Once done, you can delete the everyone account.

Good luck
DBA Freelancer
Commented:
This error usually comes when sufficient permission is not provided or there may be more. Have a look on this SQL Server error 15105

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial