Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
backup prob...I have access to all below local and remote drives

Answered backup prob...I have access to all below local and remote drives

  • Thursday, July 05, 2012 2:45 PM
     
     
    Sign In to Vote
    0

    --\\npkstadat11\DAT07_Backup\ScReporting\20120705

    BACKUP DATABASE ScReporting TO DISK = '\\npkstadat11\DAT07_Backup\ScReporting\20120705\20120705.bak'

    Msg 3201, Level 16, State 1, Line 1

    Cannot open backup device '\\npkstadat11\DAT07_Backup\ScReporting\20120705\20120705.bak'. Operating system error 5(Access is denied.).

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    --map z drive of npkstadat11 on dat07

    --'Z:\ScReporting\20120705.bak'

    BACKUP DATABASE ScReporting TO DISK = 'Z:\ScReporting\20120705.bak'

    Msg 3201, Level 16, State 1, Line 1

    Cannot open backup device 'Z:\ScReporting\20120705.bak'. Operating system error 3(The system cannot find the path specified.).

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    BACKUP DATABASE ScReporting TO DISK = '\\npkstadat11\f$\DAT07_Backup\ScReporting\20120705\20120705.bak'

    Msg 3201, Level 16, State 1, Line 1

    Cannot open backup device '\\npkstadat11\f$\DAT07_Backup\ScReporting\20120705\20120705.bak'. Operating system error 5(Access is denied.).

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    BACKUP DATABASE ScReporting TO DISK = '\\10.253.20.23\Users\20120705.bak'

    Msg 3201, Level 16, State 1, Line 1

    Cannot open backup device '\\10.253.20.23\Users\20120705.bak'. Operating system error 53(The network path was not found.).

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    BACKUP DATABASE ScReporting TO DISK = '\\npklwrrem01\Share\20120705.bak'

    Msg 3202, Level 16, State 2, Line 1

    Write on "\\npklwrrem01\Share\20120705.bak" failed: 112(There is not enough space on the disk.)

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    --Himanshu Kulkarni, Mark the thread as answered if the answer helps you. This helps others who have the same problem !!!


     

All Replies

  • Thursday, July 05, 2012 2:47 PM
     
     
    Sign In to Vote
    0
    What is your question?  the errors are pretty self explanatory

    Chuck Pedretti | Magenic – North Region | magenic.com

     
  • Thursday, July 05, 2012 2:50 PM
     
     
    Sign In to Vote
    0

    Hi  Himanshu,

        I would take a look at the Service account SQL Server is running under.  It does not have access to the shared location where you are trying to backup the file to.  

        If you have access to give the service account read/write permissions do so, and run the backup script again.


    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

     
  • Thursday, July 05, 2012 3:16 PM
     
     
    Sign In to Vote
    0

    Provide a access rights to SQL server service account at shared location.

     
  • Thursday, July 05, 2012 3:18 PM
     
     
    Sign In to Vote
    0

    Provide a access rights to SQL server service account at shared location.


    In addition to that - you can't use mapped drives from a SQL Agent job, so that would explain your z:\ problem

    Chuck Pedretti | Magenic – North Region | magenic.com

     
  • Friday, July 06, 2012 5:28 AM
     
     
    Sign In to Vote
    0

    Hello Chuck

    I can access that path from remote to remote like

    \\severname\f$\DAT07_Backup   \\severname\DAT07_Backup and do any operation like copy pasting then why from SQL you said that problem have access rights

    Moreover how to grant access to my ID to take backup (I am superuser and have access to almost every server but I cant drop DB objects rest all I can do) can you share some script or some link like this, this is not working I have tried it

    --Himanshu Kulkarni, Mark the thread as answered if the answer helps you. This helps others who have the same problem !!!


    • Edited by Himanshu Kulkarni Friday, July 06, 2012 5:40 AM need to convy more clarifiaction
    •  
     
  • Friday, July 06, 2012 5:33 AM
     
     
    Sign In to Vote
    0
    Not sure but may be your SQL server instance is configured to run as local system, try changing it to run as a network service.

    Thanks and regards, Rishabh K

     
  • Friday, July 06, 2012 9:04 AM
     
     
    Sign In to Vote
    0

    you can do this tasks when you logged on Window server with your user id & credentials in same way when SQL server tried to acces this shared location, SQL uses its service account credential to access the path. You need to give access rights on sahred path for your SQL service account to access the same via SQL server.

    Please click the Mark as Answer or Vote As Helpful  if a post solves your problem or is helpful!

     
  • Monday, July 09, 2012 8:00 AM
     
     Answered
    Sign In to Vote
    0

    this problem is solved

    SuperAdmin grant me that folder on remote to access so now I can make backup, what he did  I don't understand

    Either he make some changes in SHARED folder---but I disagree with it

    he may change in some security\login\myname or server roles ,that what I think for me only

    Is it right?

    --Himanshu Kulkarni, Mark the thread as answered if the answer helps you. This helps others who have the same problem !!!