Post reply

Backup device cannot be opened!

  • April 20, 2007 at 9:06 pm

    #116562

    Run the following script gives no error.

    BACKUP DATABASE model TO DISK='D:\model.bak'

    Run the following script gives me error.

    BACKUP DATABASE model TO DISK='D:\BACKUP\model.bak'

    Cannot open backup device 'D:\BACKUP\model.bak'. Device error or device off-line. See the SQL Server error log for more details.

    There is no backup device defined in my server system. My account is the local administrator with sa permission in the server. D drive is a local drive. Anyone knows why it it so?

    Any input will be greatly appreciated.

  • April 23, 2007 at 7:23 am

    #701919

    Does the directory 'D:\Backup' exist?

    Have a good day,

    Norene Malaney

  • April 23, 2007 at 7:31 am

    #701922

    And does the account running SQL Server have rights to this folder? Keep in mind this folder is on the server, not on your workstation.

  • April 24, 2007 at 3:08 pm

    #702273

    here's a quick way to test and/or verify what the problem is:

    declare @cmd varchar(64)

    select @cmd='dir D:\BACKUP'

    exec master..xp_cmdshell @cmd

     

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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