Answer the question
In order to leave comments, you need to log in
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
Create a backup copy of the SQL database .
SQL Server Agent .
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question