Backup on shared folder

• krishna83

  Ten Centuries

  Points: 1003

  More actions

  May 8, 2017 at 6:42 am

  #323406

  How to run SQL server backup on a shared folder?

• Thom A

  SSC Guru

  Points: 99137

  More actions

  May 8, 2017 at 7:02 am

  #1941577

  Could you elaborate a bit more? Do you simply mean you wish to create a backup on a shared folder on the network? For example (without any WITH clauses):
  BACKUP DATABASE [YourDatabase] TO DISK = '\\YourServer\SharedDirectory\SubDirectory\YourBackupFile.bak';

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• krishna83

  Ten Centuries

  Points: 1003

  More actions

  May 8, 2017 at 11:22 pm

  #1941713

  BACKUP DATABASE ABC_123 TO DISK = '\\WIN-94EATCLRNI5\Backup\ABC_123.bak';

  Msg 3201, Level 16, State 1, Line 13
  Cannot open backup device '\\WIN-94EATCLRNI5\Backup\ABC_123.bak'. Operating system error 5(Access is denied.).
  Msg 3013, Level 16, State 1, Line 13
  BACKUP DATABASE is terminating abnormally.

  I am getting above error while running backup on a shared folder.

  Thanks & Regards
  Krishna.

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  May 9, 2017 at 12:52 am

  #1941721

  krishnabudampati - Monday, May 8, 2017 11:22 PM

  BACKUP DATABASE ABC_123 TO DISK = '\\WIN-94EATCLRNI5\Backup\ABC_123.bak';

  Msg 3201, Level 16, State 1, Line 13
  Cannot open backup device '\\WIN-94EATCLRNI5\Backup\ABC_123.bak'. Operating system error 5(Access is denied.).
  Msg 3013, Level 16, State 1, Line 13
  BACKUP DATABASE is terminating abnormally.

  I am getting above error while running backup on a shared folder.

  Thanks & Regards
  Krishna.

  You should check if the account under which the SQL Server service runs has the full rights on the shared folder. 
  Have you checked that?

  Igor Micev,My blog: www.igormicev.com

• krishna83

  Ten Centuries

  Points: 1003

  More actions

  May 9, 2017 at 1:12 am

  #1941723

  I am fresher to SQL server, Could you please let me know how to check permissions.

  Thanks & Regards
  Krishna.

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  May 9, 2017 at 5:50 am

  #1941762

  krishnabudampati - Tuesday, May 9, 2017 1:12 AM

  I am fresher to SQL server, Could you please let me know how to check permissions.

  Thanks & Regards
  Krishna.

  You don't do that via SSMS or SQL server. Simply check them on the folder - https://technet.microsoft.com/en-us/library/cc754344(v=ws.11).aspx
  or ask the sys or network admin to do that for the sql server account.

  Igor Micev,My blog: www.igormicev.com