• surma.sql (11/19/2012)


    Hello

    I 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.