Year End Payroll Archive from Database Admin Tool

I backed up my data last night and now I am trying to archive my payroll data.  The first message I get is that the program is backing up my company.  My back ups take hours.  How can I keep the payroll archive process from backing up my data again?  

Parents
  • 0

    I had the same issue where it took a long time to backup / archive / backup new.

    I believe they want to make it idiot proof since they would get the calls / I was patient and the entire process went excellent.

    Previously never worked with such and easy year end system.

  • 0 in reply to Ken Mac

    If you don't mind my asking - how many payroll records did you archive and how many hours did it take?  We have two companies.  The one with 448 records took 8 hours start to finish.  Our other company is much, much larger.  We're concerned about how long it will take. 

  • 0 in reply to JClark

    I had around 2,000 records and it took 1 hour.  I can certainly see your frustration.  I have been having Microsoft Server Software issues, it's getting hammered with Microsoft processes running using 100% CPU which kills Sage performance.  My IT guy had to load a special software to determine which processes were the culprit and try to kill them since we push our MS upgrades out by another means.  I wonder if you have other things going on with server performance not related to Sage but impacting processing speed?  Good luck

  • FormerMember
    0 FormerMember in reply to Ken Mac

    (in reference to Judy's post) It actually takes about 3-4 hours each company and the DB backup file is anywhere from 25-30GB for each company even though the DB is only at most 2GB with the smallest company at 200MB. What version of SQL are you using Ken? Express or full?

Reply
  • FormerMember
    0 FormerMember in reply to Ken Mac

    (in reference to Judy's post) It actually takes about 3-4 hours each company and the DB backup file is anywhere from 25-30GB for each company even though the DB is only at most 2GB with the smallest company at 200MB. What version of SQL are you using Ken? Express or full?

Children
No Data