• DURGESH-769360 (8/16/2009)


    Hi,

    I stopped the user who is accessing the database and now i am getting the following message

    Server: Msg 3201, Level 16, State 2, Line 1

    [highlight=#ffff11]Cannot open backup device '\\xyz\Databackups\[/highlight]ddd.BAK'. Device error or device off-line. See the SQL Server error log for more details.

    Server: Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    You will most likely find that the account the SQL runs under doesn't have permissions on your backup folder.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective