We help IT Professionals succeed at work.

SQL 2008 R2

130 Views
Last Modified: 2017-12-24
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

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 problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION