SQL Server 2000 Remote Backup

SQL Server 2000 Remote Backup -- Step 1: MAP network disks in SQL Server
-- 192.168.60.203 is a remote backup machine.
-- Administrator is the username used to log on to the remote backup machine.
-- 111111 is the remote machine Password
-- Bak is a fully shared folder.
-- Note: (Z: there must be a space at the end)
Exec Master .. xp_mongoshell ' Net use Z: \ 192.168.60.203 \ Bak 111111/User: 192.168.60.203 \ Administrator '


-- Step 2: Back up the database
-- Differential is a differential data backup. A full backup is required before differential backup.

Backup   Database Dbname To   Disk = ' Z: \ back. dat '   With Differential


-- Step 3: delete the ing after the backup is complete
Exec Master .. xp_mongoshell ' Net use Z:/delete '