Post reply

Backup Database

  • June 6, 2006 at 6:27 am

    #117923

    From server A: i'm trying to backup to server B:

    BACKUP DATABASE [DATABASENAME]

    TO DISK =N'\\servername\D$\sql_backup\databasename.bak'

    I'm getting this error:

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

    Cannot open backup device '\\servername\D$\sql_backup\databasename.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.

    any ideas?

    thanks

     

     

  • June 6, 2006 at 6:49 am

    #641945

    Does the account that your SQL Server service is logging in with have access to that machine?

     

  • June 6, 2006 at 8:08 am

    #642009

    good question, I don't know, I will check this out and get back to you...thanks

  • June 6, 2006 at 1:22 pm

    #642123

    You're right, was the sql agent permissions to access that drive

    thanks

  • June 7, 2006 at 7:38 am

    #642267

    I've only notice, when I tried backup to another network locations, I had problem with UNC path... I solve this problem by mapping remote disk via "net use ... " command and use this local path with SQL backups...

     

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

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