Shulou(Shulou.com)06/01 Report--

Database server and backup server information

Database server: 10.117.130.147

Backup server: 10.117.130.148

Second, the DB side and backup side control account configuration 1. Backup server creates backup users

2. The database server creates backup users.

Third, the backup machine creates a shared directory

Create a shared folder msserver

Check the msserver right-click property

Select sharing in the attribute tab and click Advanced sharing.

Check share this folder and click permissions

Click the Advanced button

Click the find now button

Select msservery user and click OK button

Click the OK button

Check full Control, and then click OK

Click OK

Click close

4. Set up NFS on database server

Right-click on the computer and select add a network location

Select a custom network location and click next

Enter the shared address of the backup server\ 10.117.130.148\ msserver, and click next

Click next

Click finish

Create and edit files to a shared folder on the database side

View the files created on the database side on the standby

Fifth, the database server sets the sqlserver 2008r2 backup plan

Right click on the computer to select management to open the server manager, click configure to select services, find the sqlserver-related service SQL Server (MSSQLSERVER), and set login management permissions

Right-click to select properties

Select login in the properties window, click on this account, click Browse

Click Advanced

Click find now

Select the shared folder operation user msserver, and click OK

Click OK

Enter the user password for msserver

Restart the service SQL Server (MSSQLSERVER)

Set up the SQL SERVER proxy service and start it in the same way

Log in to SQL Sserver Management Studio and set up the ms sqlserver backup maintenance plan

Expand and log in to logcal, expand management, and click maintenance Plan

Right click to open the maintenance Plan Wizard

Click next

In order to test here, edit the job plan name as msserver_backup, the plan type is repeated, and the execution frequency is 15 minutes per day. The start and end time is set as shown in the figure. Click OK.

Click next

Select backup database (full)

Click next

Database options pay attention to the selection of database

Click the down arrow and select the master database to test

Modify the backup destination directory to the directory pointed to by NFS:\ 10.117.130.148\ msserver

Click finish

Click close when you are finished

Test whether the maintenance plan can be executed manually

By clicking on the maintenance plan created, right-click to view the history and make sure that it can be executed manually.

The set maintenance plan is to make a full backup of masterdb every 15 minutes. The database side depends on the implementation of the maintenance plan.

Backup server look at backup files

MS SQL Server's NFS remote backup setup is complete!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.