Link to home
Start Free TrialLog in
Avatar of leop1212
leop1212Flag for United States of America

asked on

SQL 2008 R2

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
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of Jason clark
Jason clark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial