Download Sophos for Microsoft SharePoint startup guide
Transcript
Sophos for Microsoft SharePoint For more information on using SQL Server Management Studio see, http://technet.microsoft.com/en-us/library/ms175134.aspx. 1. Create the Sophos for Microsoft SharePoint login on the mirror server instance: [Mirror]> CREATE LOGIN [<domain name>\SophosSharePoint] FROM WINDOWS <domain name> must be replaced with the actual domain of your Sophos for Microsoft SharePoint server, or with the machine name if in a Workgroup. For more information on setting up login accounts, see http://technet.microsoft.com/en-us/library/ms366346.aspx. 2. Perform a full backup for each of the four Sophos for Microsoft SharePoint databases from the principal server: [Principal]> BACKUP DATABASE [SavspCnfg] TO DISK = '<path>\SavspCnfg.bak' [Principal]> BACKUP DATABASE [SavspDir] TO DISK = '<path>\SavspDir.bak' [Principal]> BACKUP DATABASE [SavspQuar] TO DISK = '<path>\SavspQuar.bak' [Principal]> BACKUP DATABASE [SavspRprt] TO DISK = '<path>\SavspRprt.bak' <path> must be replaced with a path to a folder where the backup is to be stored. For more information on preparing a mirror database for mirroring, see http://technet.microsoft.com/en-us/library/ms189047.aspx. 3. Make the database backup available on the mirror server and restore each database to the mirror server instance. This will set the mirrored databases to Mirror, Synchronized/Restoring state. [Mirror]> RESTORE DATABASE [SavspCnfg] FROM DISK = '<path>\SavspCnfg.bak' WITH NORECOVERY [Mirror]> RESTORE DATABASE [SavspDir] FROM DISK = '<path>\SavspDir.bak' WITH NORECOVERY [Mirror]> RESTORE DATABASE [SavspQuar] FROM DISK = '<path>\SavspQuar.bak' WITH NORECOVERY [Mirror]> RESTORE DATABASE [SavspRprt] FROM DISK = '<path>\SavspRprt.bak' WITH NORECOVERY <path> must be replaced with a path to a folder where the backup is held. If the path names of the principal and mirror databases differ then it will be necessary to use the MOVE option of the RESTORE command. For example: [Mirror]> RESTORE DATABASE [SavspCnfg] FROM DISK = <path>\SavspCnfg.bak' WITH NORECOVERY, MOVE 'SavspCnfg' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Savspcnfg.mdf ', MOVE 'SavspCnfg_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SavspCnfg_1.LDF' For more information on preparing a mirror database for mirroring, see http://technet.microsoft.com/en-us/library/ms189047.aspx. 18