SQL Server process database automatic backup (1)

zhaozj2021-02-12  178

First create a database maintenance plan, and go all the way.

Then there is this job in the homework, the key is that the steps have to be rereaded.

Open its steps, write the following two sentences,

MASTER..XP_CMDSHELL 'NET Use //192.168.0.162/test 123 / user: domain / administrator'backup Database Master to disk =' // 192.168.0.162/test/msdb.bak '

Test is a shared folder, and Administrator is a user name of the local machine, and 123 is a password.

OK, I will tell a fall, come back and see again.

转载请注明原文地址:https://www.9cbs.com/read-7043.html

New Post(0)