L
L
Luan2022-03-10 16:48:20
Windows
Luan, 2022-03-10 16:48:20

What are good backup tools for MS SQL?

Prompt good tools for automatic backup. We planned to use urbackup, but it did not fit our version.
1 server - SQL server is located on the local machine
2 server - a separate machine that has Internet access and access to the SQL server.
3 server - for backup files is located remotely.
Are there any tools to put it on server 2 and easily transfer backups to a remote server?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
K
Konstantin Tsvetkov, 2022-03-10
@Luan

Create a backup copy of the SQL database .
SQL Server Agent .

R
rPman, 2022-03-10
@rPman

configure master-slave replication to the second server and already on this second server to make backups in any way, this will not affect (in terms of load) the main one and will be quite effective (since the read load of this backup server is zero)
I vaguely remember how I (on oracle but I think this can be done everywhere) disabled all indexes on the slave base except for pk and the write load on this database was the lowest

D
Drno, 2022-03-10
@Drno

mysql dump??))
Veeam seems to be...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question