Post reply

Full Backup on Network Drive is Failing

  • October 21, 2013 at 10:24 am

    #299340

    Hi Guys

    I am trying to take the full Backup on Network drive and keep getting Error

    sg 3201, Level 16, State 1, Line 3

    Cannot open backup device '\\............................' Operating system error 5(Access is denied.).

    Msg 3013, Level 16, State 1, Line 3

    BACKUP DATABASE is terminating abnormally.

    any work around please ?

    --------------------------------------------------------------------------------

  • October 21, 2013 at 10:28 am

    #1660194

    Have you verified that the SQL Server service account has access to write to that network directory?


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 21, 2013 at 10:52 am

    #1660199

    Another approach would be to have the backup directed to a local drive. Then have a scheduled task copy the backup files from the local drive to the network drive. This would give you control over the individual steps and you'd still be taking backups even if the share isn't available.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 21, 2013 at 11:14 am

    #1660205

    Also make sure that the permissions are set at both the share and file level. It's easy to forget one of the other.

  • October 21, 2013 at 12:53 pm

    #1660239

    there was permission issue with account.. thanks for all your support .. backup is running now on network drive

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply