Log transfer (1)

xiaoxiao2021-03-06  60

Permissions are not set, refer to the settings below to make a mapping (assuming the database backup to the B server):

1. Machines a, b Create a Windows user of the same name, the user group is set to Administrators, and set the same password, as a valid access user of the backup folder folder, Operation: My Computer - Control Panel - Management Tools - Computer Management - User and Group - Right-click User - New User - Create a user who is underway Windows on Administrator group

2. On the B-RarC, create a shared directory, do the storage directory for the backup file, Operation: My Computer - D: / New Category, named: BAK - Right click this new directory - Properties - Properties - - Share - Select "Shared This Folder" - Use "Permissions" to set the specific user permissions to ensure that the user created in the first step has all permissions to the folder - determine

3. Set up the MSSQLServer and SQLServerAgent service - Program - Administrative Tool - Services - Right-Type MSSQLServer - Property - Login - Select "This Account" - Enter or select Windows created in the first step. Log in to User Name - Enter the user's password in "Password" - Determine - the same method Sets SQLServerAgent

4. Complete mapping on the B machine BAK directory on the A machine

5. Query the following statement in the query analyzer, check whether it is successful: Exec master..xp_cmdshell 'DIR mapping drive letter

转载请注明原文地址:https://www.9cbs.com/read-88425.html

New Post(0)