Avatar of leop1212
leop1212
Flag 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
DatabasesMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Jason clark

8/22/2022 - Mon
sammySeltzer

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
Jason clark

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes