Sqlserver remote backup and recovery

-- The following statement must be executed one by one in the query analyzer. Delete the annotation mark "--" run, and then add "--". Then, execute the next statement.
-- Step 1: create a shared folder on the backup machineProgramCode(Or cmd window)
-- Master .. xp_mongoshell 'md D: \ sqlbak'
-- Master.. xp_mongoshell 'net share sqlbak = D: \ sqlbak'

-- Step 2: Establish a shared credit relationship
-- Exec master.. xp_mongoshell 'net use \ 192.168.1.101 \ sqlbak 2008/User: domain \ wufeng1'

-- Step 3: Back up the database
-- Backup database mxsoftoa to disk = '\ 192.168.1.101 \ sqlbak \ mxsoftoa. Bak'
-- Differential backup
-- Backup database mxsoftoa to disk = '\ 192.168.1.101 \ sqlbak \ mxsoftoa. Bak' with differential

-- Step 4: delete shared folders and call them in program code (or in the CMD window)
-- Master.. xp_shareshell 'net share sqlbak/delete'

-- Step 5: Restore the database
-- Restore database mxsoftoa from disk = '\ 192.168.1.101 \ sqlbak \ mxsoftoa. Bak'
-- Differential recovery
-- Restore database mxsoftoa from disk = '\ 192.168.1.101 \ sqlbak \ mxsoftoa. Bak' with norecovery