EN - Work-IT backup batch file issue fix

EN - Work-IT backup batch file issue fix

Quote
Question

How to fix the backup batch file error?

Quote
Answer
                                                                                                                                                                                                                  
When you want to set up automatic backup for the Work-IT database, you are going to use this batch file backupdb.bat.

As mentioned in the earlier articles, this file can be found in both backup-related articles

EN - Backup Work-IT database

Or

EN - Advance backup Work-IT database

Sometimes you encounter this issue when you try to run the backupdb.bat file :





In similar issues, you need to add the Windows admin user (in this example, "workit") to the SQL Server logins and assign the required roles:

(a) Add the Windows user to the SQL Server Logins list in SSMS (SQL Server Management Studio)

If the user does not appear under Security → Logins, then follow these steps to add the user. Otherwise, skip this section and continue with section (b)
  1. After logging into SSMS, go to Security → Logins, right‑click, and select "New Login…"
  2. Click on "Search" to locate and add the Windows user.
  3. Enter the user name (here: "workit")
  4. Click on "Check Names" to verify and locate the user.


      5. Once the full Windows user name appears, click "OK" to confirm and proceed.



      6. Then click "OK" once more.




(b) Assign the necessary roles to the user.

  1. Right‑click the user you have added, and select "Properties".
  2. From the ‘User Mapping’ page, select the database to which you want to assign roles for the user (In this example, the database name matches the user name, "workit".).
  3. Select at least these two roles:                                         (In my example, I assigned all roles to this user.)
            - db_backupoperator
            - db_owner
      4. Then click "OK" to confirm.



    • Related Articles

    • EN - Advance backup Work-IT database

      Question How to back-up the Work-IT database automatically each day weekly or for a couple of days weekly? Answer Sometimes it is more secure for our valuable database to have weekly 7 backups (or less) instead of one backup file that will be ...

    • EN - Backup Work-IT database

      Question How to backup Work-IT database manually, or schedule daily backup automatically ? Answer (a) Create Work-IT database backup manually 1- Open Microsoft SQLServer Management Studio, and login with "SQL Server Authentication" and "sa" ...

    • EN - Work-IT: Setup Course - Basic

      Question How to start quickly with Work-IT?  Answer   If you want to get to know how to setup Work-IT, you can do the free online course in the Hoogendoorn AcadeMe.  But if you want to have a quick look at the videos about Work-IT then click the ...

    • EN - Using the interface of Work-IT

      I am new to Work-IT. Can you give some tips and tricks on how to use the program? We want to make working with Work-IT as easy and fun as possible. Have a look at the video below for some trips and tricks. Want to learn more about how to work with ...

    • EN - Creating a report in Work-IT

      How do I create a new report in Work-IT? You can create a  new report in Work-IT in several ways. Each tab of Work-IT has its report button from which you can start a report. The video below shows an example of how to setup a simple report. This can ...