Log in

Please declare the exact username and password!

Forgot password?

Đăng Ký

Bạn phải điền đầy đủ thông tin đăng ký!

  

    [Hướng Dẫn] Sữa lỗi Backup SQL (Access is denied.)

      Administrators
      ๖ۣۜAdministrators

      Posts Posts : 650

      Points Points : 63356

      Thanks Thanks : 760

      Gender Gender : Male

      JoinDate JoinDate : 2010-11-25

      #1

       Sun Jan 13, 2013 9:57 pm

      SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

      Recently I formatted my computer and installed fresh SQL Server in it. I installed AdventureWorks database in my database. Once done I wanted to run few test scripts on my database. Just like every DBA, I decided to take backup of my database – this way I can restore it back to attain original database state. As soon as I ran the backup command I ended up with following error. This error is due to permissions issue on the local disk and user account which is running SQL Server.
      Msg 3201, Level 16, State 1, Line 1
      Cannot open backup device ‘C:\AdventureWorks.bak’. Operating system error 5(Access is denied.).
      Fix/Resolution/Workaround:
      I checked which user account my SQL Server services are running.

      I gave full permission to that account to get read of the error.

      Bạn chuột phải vào ổ muốn backup chọn Properties sang Tab Security chọn User và chọn Full Control

      NOTE: This whole experience was done on the my personal machine and not on production server. Please check with your network administrator for permission on production server.

      Attachments
      [Hướng Dẫn] Sữa lỗi Backup SQL (Access is denied.) AttachmentSua loi Backup SQL.doc
      You don't have permission to download attachments.
      (973 Kb) Downloaded 9 times