SQL Server 2008 How to create a recurring automatic backup task (ii) _ Offsite Backup

Get ready:

Two computers in the LAN. Home computer, back up your computer.

Principle: Implemented through database maintenance plan.

Operation Steps:

One, create an account liuxh and password 123 (custom) on the backup PC and the host computer

Second, create the backup folder Backfile and share it to the specified user Soft1_developer6 in the backup PC.

1. Select User

2. Assigning Permissions

The above step is to open the folder to share. the remaining steps are the same as SQL Server 2008 How to create regular automatic backup tasks, and save the path to the folder directory of the shared directory.

SQL Server 2008 How to create a recurring automatic backup task (ii) _ Offsite Backup