Remote Backup of MSSQL Server

-- Backup environment: Back up the database (TEST) of the database server (192.168.1.8) to C $ under (192.168.1.145) -- first, create a exec ing with the client exec master .. xp_cmdshell 'net use Z: // 192.168.1.145/C $ "password"/User: 192.168.1.145/Administrator '/* -- Note: Z: The drive letter corresponding to the local machine mapped to the network path, the corresponding // 192.168.1.145/C $ to be mapped to the following Backup is the network path 192.168.1.145/administrator192.168.1.145 which is the name of a remote computer, administrator is the password of the administrator user specified in the logon username and password -- */-- Second, backup the database test to disk = 'z:/test. bak' -- last. after the backup is complete, delete the exec ing exec master .. xp_mongoshell 'net use Z:/delete' put the above job in sqlserver to achieve automatic backup effect. Further, You can automatically generate the backup name exec master .. xp_mongoshell 'net use Z: // 10.1.1.197/d $/dbback "123456"/User: 10.1.1.197/Administrator 'descare @ a char (80) Select @ A = 'z: /'+ Replace (replace (convert (varchar (19), getdate (), 120 ),'','-'),':','-') + '-service_korea.bak' backup database pubs to disk = @ A exec master .. xp_mongoshell 'net use Z:/delete'