Post reply

Backup/Restore via UNC path

  • August 11, 2006 at 1:36 pm

    #119317

    I've had created a login account which has admim rights to two servers Prod & Test.  I want to take a back an dump it to a directory on Test but when I run the native back up SQL statement  in query Analyzer I receive:

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

    Cannot open backup device '\\ServerName\backups\DBName.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

    BACKUP DATABASE is terminating abnormally.

    What did I do wrong ?

     

  • August 11, 2006 at 1:38 pm

    #654656

    does the sql service have access to this path?

  • August 11, 2006 at 1:43 pm

    #654658

    Yes, it does.

  • August 11, 2006 at 2:02 pm

    #654661

    I'm assuming you are referring about the login account, which has access to the path.

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

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