I
I
Igor Krivintsov2020-06-09 16:49:04
SQL Server
Igor Krivintsov, 2020-06-09 16:49:04

How to set up a database backup?

What settings I have are not correct in the backup settings. I’m making a maintenance plan, specifying which bases to backup, for example, from No. 100 to 150, the base should be backed up, which is interesting, the backup appears in the folder from No. 100 to 120, the base number, and everything beyond 120 is not backed up. If you do a manual backup, then the tabular part does not indicate where to backup, I point to the network location \\192.168.1.20\f, then everything works.

spoiler
5edf933eec394838299604.png
5edf9348d10f4523730981.png
5edf934f1a7d7985057346.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2020-06-09
@tsklab

"manual" - executes SQL Server, "maintenance plan" - executes SQL Arent using a different account.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question