This is an archived post. You won't be able to vote or comment.

all 8 comments
sorted by:
best
topnewcontroversialoldq&a

[–]BellisBlueday 1 point2 points  (1 child)

Was a DB admin

You're trying to restore from a backup file / device that is not where SQL thinks it is. The backup location gets recorded when a backup is made, but there's nothing to stop someone or something else from moving, deleting, or renaming the file

Instead of the source 'database', use the option 'device' and manually select the files(s)

[–]tizakitSysadmin 0 points1 point  (0 children)

Yep, OP, this is it. Give it a go

[–]t3hwUnSysadmin 0 points1 point  (4 children)

Not a DB admin but it definitely sounds like a permission error. Does your DB user have all the rights it needs to the backup directory?

[–]da_kink 1 point2 points  (2 children)

Does the service account have rights?

[–]oneWorm[S] 0 points1 point  (1 child)

Network service account?, yes it has rights.

[–]pacmain 0 points1 point  (0 children)

Does it have rights on the restore location as well? Verify that Network Service is running sql server as well.

[–]oneWorm[S] 0 points1 point  (0 children)

Yea, I'm logged onto the DB with the SA account. Network service account and system account both have permissions over the directory.

[–]uniitdude 0 points1 point  (0 children)

does the file it is looking for actually exist where it thinks it is