Methods of back up of Enterprise Server SQL Database

Methods of back up of Enterprise Server SQL Database

Version: 

Not any specific version.

 

Query: 

Kindly advise methods of backup of Enterprise Server SQL database.

 

Answer: 

We can only take SQL backup from SQL Server only for enterprise databases. We don't have any utility to take an enterprise backup.

Steps to take a SQL backup of the Enterprise:

Login to the SQL Server >> Select the Database >> Right Click on the Database >> Click on the Tasks >> Backup >> Provide the details to take a backup

Below are the screenshots for the same:

 

 

Please see the below link for the more detailed process for the database backup exercise:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15


    • Related Articles

    • Cannot open database 'CXSIntegration' login failed

      Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...

    • Migrating iVend Enterprise Server

      Migrating iVend Enterprise Server This article advises on the steps to follow when migrating the iVend Enterprise to a new server while retaining SAP Business One on the old server. Assumption: · SQL Server Edition of the new iVend Enterprise Server ...

    • SQL Queries : iVend Enterprise /HO database Purge

      ****************INTERNAL TO SUPPORT TEAM ( Not for Customers) ************************* Note:-This article is created only for Support team and will be done along with product expert. Environment: iVend 6.6 integrated with SAPB1 Problem Statement: ...

    • Linked server creation from SAPB1 HANA Server to SQL Server

      Environment : iVend 6.6 With SAPB1 HANA Server Problem Statement : There is need to access SAPB1 HANA tables on iVend Enterprise database Resolution : You can check out the below video link to create Linked server from HANA to SQL Server ...

    • SQL server 2016 : Database Mirroring for High Availability

      Query: Customer is planning to set up Database Mirroring for High Availability in his test environment. In SQL 2016 version is this supported? Response: Database High availability is the concept related to RDBMS and not with iVend application. Below ...