SQL Server 2012 : Error while scheduling database backup with multiple backup files

• santosh.mane

  SSChasing Mays

  Points: 611

  More actions

  July 21, 2018 at 8:10 am

  #358847

  Hi,

  Receiving attached Error while scheduling database backup with multiple backup files.
  Job was working fine till last week but I wanted to setup cleandup activity before backup hence dropped the job and started creating new job
  but now it's not allowing to create backup job with multile backup files.
  I have even restarted the Windows server and DB server but still the issue persist.
  Can you please advise or provide steps to resolve the issue?
  Appreciate your support and co-operation.
  Thanks & Regards,
  Santosh

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  July 21, 2018 at 8:20 am

  #1998498

  santosh.mane - Saturday, July 21, 2018 8:10 AM

  Hi,

  Receiving attached Error while scheduling database backup with multiple backup files.
  Job was working fine till last week but I wanted to setup cleandup activity before backup hence dropped the job and started creating new job
  but now it's not allowing to create backup job with multile backup files.
  I have even restarted the Windows server and DB server but still the issue persist.
  Can you please advise or provide steps to resolve the issue?
  Appreciate your support and co-operation.
  Thanks & Regards,
  Santosh

  First of all, the error you are getting is a folder permission error, have you checked that issue? Secondly, don't use the maintenance plans, use Ola Hallengren's SQL Server Maintenance Solution instead.
  

• santosh.mane

  SSChasing Mays

  Points: 611

  More actions

  July 21, 2018 at 11:05 pm

  #1998504

  Eirikur Eiriksson - Saturday, July 21, 2018 8:20 AM

  santosh.mane - Saturday, July 21, 2018 8:10 AM

  Hi,

  Receiving attached Error while scheduling database backup with multiple backup files.
  Job was working fine till last week but I wanted to setup cleandup activity before backup hence dropped the job and started creating new job
  but now it's not allowing to create backup job with multile backup files.
  I have even restarted the Windows server and DB server but still the issue persist.
  Can you please advise or provide steps to resolve the issue?
  Appreciate your support and co-operation.
  Thanks & Regards,
  Santosh

  First of all, the error you are getting is a folder permission error, have you checked that issue? Secondly, don't use the maintenance plans, use Ola Hallengren's SQL Server Maintenance Solution instead.
  

  We have verified permission of folder. Is this Tool free of cost and will it create any performance impact.

• jsqldba

  SSChampion

  Points: 11257

  More actions

  July 23, 2018 at 8:53 am

  #1998620

  did you check that for each file you specified that there was not a syntax error in the fileshare path?  in your screenshot, we can only see a few of them. 

  also, +1 for Ola Hallengren's scripts.  They are free and highly regarded in the SQL community.  But as anything, test it out first on a test system.  
  the backup scripts can automatically clean up files older than X hours using the CleanupTime parameter 

  https://ola.hallengren.com/sql-server-backup.html

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  July 23, 2018 at 9:21 am

  #1998626

  santosh.mane - Saturday, July 21, 2018 11:05 PM

  Eirikur Eiriksson - Saturday, July 21, 2018 8:20 AM

  santosh.mane - Saturday, July 21, 2018 8:10 AM

  Hi,

  Receiving attached Error while scheduling database backup with multiple backup files.
  Job was working fine till last week but I wanted to setup cleandup activity before backup hence dropped the job and started creating new job
  but now it's not allowing to create backup job with multile backup files.
  I have even restarted the Windows server and DB server but still the issue persist.
  Can you please advise or provide steps to resolve the issue?
  Appreciate your support and co-operation.
  Thanks & Regards,
  Santosh

  First of all, the error you are getting is a folder permission error, have you checked that issue? Secondly, don't use the maintenance plans, use Ola Hallengren's SQL Server Maintenance Solution instead.
  

  We have verified permission of folder. Is this Tool free of cost and will it create any performance impact.

  It's free and performs much better than most.