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