backup database

[LV2020]

I wonder if there's any way to backup SQL database using LabView?

[Martin_Henz]

This depends on the database system.

[Yamaeda]

If you have SQL Server you can send a SQL command to perform a backup.

https://www.mssqltips.com/sqlservertutorial/20/sql-server-backup-database-command/#:~:text=Create%20....

[LV2020]

What do you mean by database system?

I am using SQL Express server. I am writing a program to backup the database periodically and save it to a shared folder. 

[LV2020]

The backup need to be daily. 

The database name is same as the PC name and it needs to be run on multiple mchine.

in in other words one program to be run on multiple machines.

The link that you sent assumes the database name does not change. 

[Yamaeda]

---

@LV2020 wrote:

The backup need to be daily. 

The database name is same as the PC name and it needs to be run on multiple mchine.

in in other words one program to be run on multiple machines.

The link that you sent assumes the database name does not change. 

---

I'm pretty sure you can figure out how to change the name dynamically ...

Also, why would you have different DB names? That's quite unusual.

[Sebastian.Weber]

As said, every database system has its own SQL commands to backup.

For MS SQL:

Get list of all databases from server by executing

SELECT name FROM master.sys.databases

This will also include some system databases you do not want to backup, so choose the desired ones, and run the backup for each separately by executing:

BACKUP DATABASE <YourDbName> TO DISK = '<YourFileName>'

Note that the destination is a file on the machine where the server is running, not from where the commands are sent.
I don't know for MS SQL, but e.g. MariaDB does not allow to overwrite an existing backup file for security reasons, so make sure to chose new file names every time.

[Martin_Henz]

---

@LV2020 wrote:

What do you mean by database system?

---

 What you are using ... MySQL, PostgreSQL, MS SQL Server, Oracle, SQLite, MS Access, MongoDB, IBM DB2, Cassandra, MariaDB or any other database

[LV2020]

I am using my SQL