surma.sql (11/19/2012)
HelloI had one task.
I need to restore on DATABASE on [Server A] from [Server B].
[Server A] is on VINEMAPPLE Domain and
[Server B] is on mpeboe domain.
so when I try to restore DATABASE from [Server B] to [Server A] then I get below error message
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\[Server A]\stars\ABC\STARS_backup_2012_11_19_173006_6820968.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
so please help me to resolve this issue.
Thanks
Does the user who is trying to restore the database have access to the path '\\[Server A]\stars\ABC\STARS_backup_2012_11_19_173006_6820968.bak'
I don't think they will and It is more than likely an issue with Windows Security.