NEC Storage ReplicationControl SQL Option User Manual
  1. Manuals
  2. Brands
  3. NEC Manuals
  4. Software
  5. Storage ReplicationControl SQL Option
  6. User manual
NEC Storage ReplicationControl SQL Option User Manual

NEC Storage ReplicationControl SQL Option User Manual

Hide thumbs
Table of Contents

Advertisement

Quick Links

Download this manual
NEC Storage ReplicationControl
SQL Option User's Manual

Advertisement

Table of Contents
loading

Related Manuals for NEC Storage ReplicationControl SQL Option

Summary of Contents for NEC Storage ReplicationControl SQL Option

  • Page 1 NEC Storage ReplicationControl SQL Option User's Manual...
  • Page 2 © NEC Corporation 2001-2003 No part of the contents of this book may be reproduced or transmitted in any form without permission of NEC Corporation. The contents of this book may be modified without notice in the future.
  • Page 3 This manual is for readers who have basic knowledge of Microsoft SQL Server 2000 as well as experience with backup recovery. The data replication functions in the NEC Storage series that are used in this manual, are explained in the “NEC Storage Manager Data Replication User’s Manual”.
  • Page 4 The term “Microsoft SQL Server 2000” in this text refers to as either Microsoft SQL Server 2000 Enterprise Edition or the Microsoft SQL Server 2000 Standard Edition. The term “MSCS” in this text refers to the Microsoft Cluster Server. Trademarks and registered trademarks Microsoft®...

  • Page 5: Table Of Contents

    4.2.2 Snapshot Restore Command ..........................30 Metafile Handling ..............................39 Access Restriction..............................40 Chapter 5 Installation and Setting of NEC Storage ReplicationControl SQL Option ..........41 Operating Environment............................. 41 Software Installation ..............................41 Software Uninstallation ............................42 Software Update................................ 42 Setting of NEC Storage ReplicationControl SQL Option ..................
  • Page 6 6.1.2 Multiple Database Backup ..........................50 6.1.3 Recovery ................................55 6.1.4 Multiple Database Recovery..........................60 Disk Backup................................65 6.2.1 Preparation ................................ 65 6.2.2 Backup ................................66 6.2.3 Recovery ................................71 Parallel Operation on Another Node......................... 75 6.3.1 Operation as Standby Database......................... 75 6.3.2 Log Distribution..............................

  • Page 7: Chapter 1 Data Replication Overview

    Business Server Master operations Parallel processing (Online) (Backup/Search) Synchronization / Segregation operations Master Master Replication Volume Volume Volume (MV) (MV) (RV) Replication Volume (RV) NEC Storage RemoteDataReplication NEC Storage DynamicDataReplication Figure 1-1 Data Replication...

  • Page 8: Functions By Product

    Ver2) Creates an RV between different disk arrays. Supported by the NEC Storage3000/4000 series. * The replication management function in NEC Storage Manager can be used by introducing NEC Storage DynamicDataReplication or NEC Storage RemoteDataReplication. NEC Storage ReplicationControl Operates the replication function. Provides the CLI (Command Line Interface) and the API (Application Program Interface).
  • Page 9 Chapter 1 Data Replication Overview The NEC Storage Manager product provides functions for the administrator to understand the disk array configuration and operating state of the NEC Storage series with ease. The following products are available for NEC Storage Manager.

  • Page 10: Data Replication Advantages

    It is also possible to resynchronize with (restore to) the status of the RV. Figure 1-3 Data Replication operation Provides the NEC Storage DynamicDataReplication in a disk array and the NEC Storage RemoteDataReplication between the disk arrays with the same visibility (operability).
  • Page 11 Chapter 1 Data Replication Overview Can unify the management of data replications by using NEC Storage Manager. Can display and set the operational states of data replications through graphical interfaces. Operation Status Display Window List Display Window NEC Storage Manager...

  • Page 12: Examples Of Using Data Replication

    Chapter 1 Data Replication Overview The RV that has been separated from the MV at an arbitrary time by using the data replication function can be used for other purposes. Because the disconnected RV is independent from the MV, using the RV will bring the following effects: Backup High-speed backup...

  • Page 13: Chapter 2 Overview Of Nec Storage Replicationcontrol Sql Option

    By applying NEC Storage ReplicationControl SQL Option product in combination with the data replication (NEC Storage DynamicDataReplication or NEC Storage RemoteDataReplication), the Microsoft SQL Server 2000 database built on the NEC Storage series is able to create a snapshot without suspending operations. Also, the snapshot is available in backup or parallel processing.

  • Page 14: System Configuration

    To install and use the data replication, the following hardware devices are required. (1) Disk array (NEC Storage Series) The NEC Storage3000/4000 series disk array (the Replication Director is required separately) equipped with a data replication (NEC Storage DynamicDataReplication; NEC Storage RemoteDataReplication), or the NEC Storage 2000 series disk array applies.
  • Page 15 (5) NEC Storage RemoteDataReplication A function that facilitates data replication between the different disk arrays. The NEC Storage ReplicationControl SQL Option product operates in linkage with either of the Microsoft software programs below. (1) Microsoft SQL Server 2000 Enterprise Edition...

  • Page 16: Backup

    Chapter 2 Overview of NEC Storage ReplicationControl SQL Option The operational application of making backup copies using an RV is described below. (1) Backup from an RV to a magnetic tape medium This is the backing up of an RV for an MV to a magnetic tape medium.
  • Page 17 Chapter 2 Overview of NEC Storage ReplicationControl SQL Option (2) Using as a disk backup This refers to the use of an RV as a backup copy of an MV. This can be used as a disk medium backup without suspending operations because the MV and the RV are synchronized and separated during the time period when the load on the business operations that use the Microsoft SQL Server 2000 is lower.
  • Page 18 This makes it becomes possible to execute the database search work without affecting the database update work. The NEC Storage ReplicationControl SQL Option must be installed on the server performing the search work.

  • Page 19: Parallel Processing Of Operations Accompanied By Update

    Chapter 2 Overview of NEC Storage ReplicationControl SQL Option By creating and separating an RV of the business operation database, the database can be used by other servers. This is used for constructing test environments. When constructing an environment, replications of the database can be made without suspending operations using the Microsoft SQL Server 2000.

  • Page 20: Chapter 3 Database System Configuration

    Chapter 3 Database System Configuration Chapter 3 Database System Configuration Database configuration and concept of backups for the Microsoft SQL Server 2000 are briefly described below. For details, refer to the Microsoft SQL Server 2000 Books Online. The Microsoft SQL Server 2000 database consists of three files; the primary data file, the secondary data file and the log file.
  • Page 21 The NEC Storage ReplicationControl SQL Option does not specify a static point on other files than those of database. Place only database files in the backup-target MV.

  • Page 22: Data Replication System Design

    Replication User’s Manual (Installation and Operation Guide for Windows)”. The concept of using the snapshot backup created by NEC Storage ReplicationControl SQL Option as a backup to the master operations is described below along with the restoration model for Microsoft SQL Server 2000 Books Online.

  • Page 23: Concept Of Parallel Processing In Other Nodes

    Chapter 3 Database System Configuration An explanation on using the snapshot backup created by the NEC Storage ReplicationControl SQL Option for parallel operations on Microsoft SQL Server of other nodes is offered below. By the snapshot backup, separated database file can be used as a search database by other servers.

  • Page 24: Operation Automatization

    Chapter 3 Database System Configuration The tape backup system, which used data replication, requires a linkage operation between the business operation side and the backup server side. NetBackup is available the backup software provided with the linkage function between servers. When using ARCserve and BackupExec, job scheduling software programs are required.

  • Page 25: Chapter 4 Functions Of Nec Storage Replicationcontrol Sql Option

    This chapter explains the its operational outline, command operation methods, display of various states, as well as some notes on the metafile management of the snapshot backup that is a function of the NEC Storage ReplicationControl SQL Option operating on the business server.

  • Page 26: Snapshot Backup Operations

    Chapter 4 Functions of NEC Storage ReplicationControl SQL Option The snapshot backup operation includes: (1) stopping the update I/O of Microsoft SQL Server 2000; (2) creating metafile; (3) flushing MV; (4) separating MV/RV. Backup Server Business Server (1) Stopping the database I/O...

  • Page 27: Snapshot Restore Operations

    Chapter 4 Functions of NEC Storage ReplicationControl SQL Option The snapshot restore operation includes: (1) acquiring the MV information from the metafile; (2) unmounting MV; (3) restoring from RV to MV; (4) mounting MV; (5) restoring database. Backup Server Business Server...

  • Page 28: Commands

    * Operation rights are required for the users belonging to Administration group. When using the NEC Storage ReplicationControl SQL Option’s commands, it is necessary to specify a configuration so that the NEC Storage ReplicationControl directly issues the replication operation I/O issuing path to the disk array.
  • Page 29 When specifying multiple pair volumes, describe the specification (-file file_name) in the replication operation file. For information on the volume type and replication operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. When specifying a drive name with regard to a volume consisting of multiple partitions, all the partitions become included in the operation by specifying the drive name for any of the partitions.
  • Page 30 Unless well versed in OS and file system operations for Windows, Read Only (-rvacc ro) should not be specified for the RV access restriction. For details, refer to 3.6 “RV Access Restrictions Setting” of the “NEC Storage Manager Data Replication User’s Manual (Installation and Operation Guide for Windows)”.
  • Page 31 This function can be used only when “NEC Storage DynamicDataReplication Ver2” has been installed in the disk array. For details about this function, refer to the “NEC Storage Manager Data Replication User’s Manual (Function Guide)” and “NEC Storage Manager Data Replication Command Reference”.
  • Page 32 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option Start message SnapshotBackup Start YYYY/MM/DD hh:mm:ss DataBase db_name MV:physical-disk-no ld_name type Volume_name Path RV:physical-disk-no ld_name type Volume_name Path End message SnapshotBackup Normal End YYYY/MM/DD hh:mm:ss DataBase db_name MV:physical-disk-no ld_name type Volume_name...
  • Page 33 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option SnapshotBackup Start YYYY/MM/DD hh:mm:ss DataBase db_name MV:physical-disk-no ld_name type Volume_name Path RV:physical-disk-no ld_name type Volume_name Path Flush Start YYYY/MM/DD hh:mm:ss Flush Normal End YYYY/MM/DD hh:mm:ss Separate Start YYYY/MM/DD hh:mm:ss Separating..Separate...
  • Page 34 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option (1) Should be set as a pair. (2) Should not be during restoration execution. (3) Should be foreground. Pairs targeted for operation (4) Should not be in the freeze status. (5) Should be registered in the volume correspondence table.
  • Page 35 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option Operation Example An example of snapshot backup operation is shown below. C:\>iSMsql_snapshotbkup -db snap -metafile c:\snap\snapdat.dat -wait 2 SnapshotBackup Start YYYY/MM/DD hh:mm:ss DataBase snap MV: 4 dev001 \\?\Volume{3a78b50b-0f0b-11d5-9c71-00004c7929e8}\ RV: 5 dev002...

  • Page 36: Snapshot Restore Command

    When simultaneously performing snapshot backups on multiple databases, specify multiple database names in the database operation file. For details of the database operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. (2) Specifying the metafile (-metafile metafilename or -metafolder metafolder_name) For the metafile, a metafile name incorporated during snapshot restoration can be specified.
  • Page 37 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option For information on setting options, refer to the “NEC Storage Manager Data Replication Command Reference”. (4) Specifying the copying range (-cprange) Normally, only the differential area (diff) between MV and RV is copied. However, this option can specify explicitly that the full area be copied.
  • Page 38 “Password:” Enter a password. Those specifications can be described in the database operation file. For details of the database operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. (10) Specifying the instance name (-server instance_name) The computer name and the instance name when connecting to a labeled instance can be specified.
  • Page 39 The computer name must be either a local computer name, or a virtual computer name in the MSCS (Microsoft Cluster Server) environment. Those specifications can be described in the database operation file. For details of the database operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. (11) Specifying restoration mode (-remode) With snapshot restoration, the kind of database restoration can be specified.
  • Page 40 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option The iSMsql_snapshotrst command is used to output messages to databases on which snapshot restorations are performed when the snapshot restoration operation starts and ends as well as when the restoration operation starts and ends.
  • Page 41 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option RV:physical-disk-no ld_name type Volume_name Path Restore Start YYYY/MM/DD hh:mm:ss Restoring..Restore Normal End YYYY/MM/DD hh:mm:ss SnapshotRestore Normal End YYYY/MM/DD hh:mm:ss MV:physical-disk-no ld_name type Volume_name Path RV:physical-disk-no ld_name type Volume_name Path Execution Conditions When performing restoration, it is necessary to meet the following conditions.
  • Page 42 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option Registered in the volume correspondence table. Should be a basic volume. MV must be a disk array Operation target pair (1) Set as a pair. under its own host’s (2) In the separate status.
  • Page 43 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option Operation Example Shows an example of the snapshot restoration operation. (1) An example of not waiting for the end of command until the restoration is completed. C:\>iSMsql_snapshotrst -db snap -metafile c:\snap.dat...
  • Page 44 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option (2) An example of waiting for command completion until restoration is completed. Monitors the processing state in 2-second intervals by specifying -wait 2. C:\>iSMsql_snapshotrst -db snap -metafile c:\snap.dat -wait 2 SnapshotRestore...

  • Page 45: Metafile Handling

    Chapter 4 Functions of NEC Storage ReplicationControl SQL Option The metafile created when executing the snapshot backup command is described below. One metafile is required for each backup. The metafile contains the target database’s original file configuration and the transaction log state information.

  • Page 46: Access Restriction

    A user belonging to the Administrators group must execute the ReplicationControl command. Therefore, A user belonging to the Administrator group also must be executed the NEC Storage ReplicationControl SQL Option. It is essential that accounts connected to Microsoft SQL Server 2000 must have the right to access all...

  • Page 47: Chapter 5 Installation And Setting Of Nec Storage Replicationcontrol Sql Option

    Microsoft SQL Server 2000 (SP2 or later) has been installed. To install NEC Storage ReplicationControl SQL Option, follow the procedure below. The NEC Storage ReplicationControl SQL Option is connected to the target MV and installed on a server installed with Microsoft SQL Server 2000. Additionally NEC Storage ReplicationControl...

  • Page 48: Software Uninstallation

    (1) Log on as the Administrator. (2) Check that the command for the NEC Storage ReplicationControl SQL Option is started. If it is started, either make the end of processing wait or terminate the command for the NEC Storage ReplicationControl SQL Option by force.

  • Page 49: Replication Volume Preparation

    Chapter 5 Installation and Setting of NEC Storage ReplicationControl SQL Option The database is designed and constructed as a Replication Volume of the database to which the NEC Storage ReplicationControl SQL Option is applied. For details, refer to the “NEC Storage Manager Data Replication User’s Manual (Installation and Operation Guide for Windows)”.

  • Page 50: Change Of Worker Thread Maximum Number

    When the number of available worker threads has been used up and new worker threads cannot be created, the NEC Storage ReplicationControl SQL Option results in an abnormal end, displaying the following message: iSM13689: Failed to snapshot execution.

  • Page 51: Chapter 6 Operations Of Nec Storage Replicationcontrol Sql Option

    Describes operations to save from the snapshot backup to the tape medium using the backup server without suspending operations by using the NEC Storage ReplicationControl SQL Option. Here, the procedure is operated with MV/RV in the separation state and with MV/RV synchronized immediately before backup.

  • Page 52: Backup

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option The procedure for performing snapshot backup is described. The backup target data files are already set in terms of pairs, with the operations running. Metafiles are placed in a shared disk. The shared disk where metafiles are placed shall be accessible from both the business server and the backup server.
  • Page 53 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1. Remove the drive name for the backup target disk (Backup Server) Remove the drive name for the backup target disk on the backup server side by executing the MOUNTVOL command to prevent new access. When using a service to monitor the disk state, it is necessary to stop the service before executing the MOUNTVOL command.
  • Page 54 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option...
  • Page 55 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 5. Issue snapshot backup command (Business Server) Issue the snapshot backup command. When using a service to monitor the disk state, it is necessary to stop the service before executing the snapshot backup. Start the service after executing the snapshot backup.
  • Page 56 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 8. Tape backup (Backup Server) Copy the data files and log files copied in the RV, to a tape as a backup by using the backup software. Copy the metafiles of the shared disk to a tape.

  • Page 57: Multiple Database Backup

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option This section describes procedures for simultaneously performing snapshot backups on multiple databases. The backup target data files are already set in terms of pairs, with the operations running. Metafiles are placed in a shared disk. The shared disk where metafiles are placed shall be accessible from both the business server and the backup server.
  • Page 58 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Figure 6-5 Snapshot Backup...
  • Page 59 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1. Prepare a database operation file Prepare a database operation file. For details of the database operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. snap_dbfile.txt #db:db_name...
  • Page 60 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 5. Issue the replication command (Business Server) Issue the replication command. MVs and RVs are synchronized. iSMrc_replicate -mv d: -mvflg drv -wait iSMrc_replicate -mv e: -mvflg drv -wait iSMrc_replicate -mv f: -mvflg drv -wait...
  • Page 61 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option...
  • Page 62 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 6. Issue the snapshot backup command (Business Server) Issue the snapshot backup command. When using a service to monitor the disk state, it is necessary to stop the service before executing the snapshot backup. Start the service after executing the snapshot backup.
  • Page 63 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option MOUNTVOL f: \\?\Volume{d9ea193c-9d59-11d6-ab08-806d6172696f}\ Procedure 8. Mount the backup target disk (Backup Server) Mount the backup target disk on the backup server side. When using a service to monitor the disk state, start the service after executing the mounting.

  • Page 64: Recovery

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option The procedure for performing recovery from the backup obtained through snapshot backup is described here. It is assumed that errors occurred in MV’s data file and the backup and the metafile previously where snapshot backup was obtained are stored in the tape.
  • Page 65 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1. Create transaction log backup (Business Server) Create a transaction log backup when errors occur in Microsoft SQL Server 2000’s data disk. T-SQL : BACKUP LOG snap TO DISK = ‘g:\sql\backups\trbl.dat’ WITH NO_TRUNCATE...
  • Page 66 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 4. Restore from the tape to the RV (Backup Server) Restore data from the tape to the RV by using the backup software. Backup software such as Data file ARCserve...
  • Page 67 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 8. Execute snapshot restoration (Business Server) Execute a snapshot restoration by specifying the -remod norecovery option and the RV protection. When using a service to monitor the disk state, it is necessary to stop the service before executing the snapshot restoration.
  • Page 68 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 10. Apply transaction log (Business Server) Apply the transaction log with Microsoft SQL Server 2000. The transaction log is applied in the order of performing backup of the transaction log extracted after snapshot backup.

  • Page 69: Multiple Database Recovery

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option The procedure for performing recovery from the backup of multiple databases obtained through a snapshot backup is described in this section. It is assumed that an error occurred in MV’s data file and the backup and the metafile previously obtained through a snapshot backup are stored in the tape.
  • Page 70 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option...
  • Page 71 Save the transaction log backup file in a highly reliable disk. Procedure 1. Prepare a database operation file Prepare a database operation file. For details of the database operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. snap_dbfile.txt...
  • Page 72 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option associate the volume with the file system. iSMrc_mount -drv d: iSMrc_mount -drv e: iSMrc_mount -drv f: Procedure 5. Restore data from the tape to the RV (Backup Server) Restore data from the tape to the RV by using the backup software.
  • Page 73 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Flush the file system of the recovery target disk on the backup server side and then write the still-unwritten data in the file system buffer to the disk. iSMrc_flush -mvol \\?\Volume{d9ea193d-9d59-11d6-ab08-806d6172696f}\...
  • Page 74 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Performing snapshot restoration Log file Log file Data file Data file Data file Data file Log file Log file Metafile Shared disk Figure 6-15 Operation to Execute Snapshot Restoration...
  • Page 75 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 10. Reconfigure the drive name for the recovery target disk (Backup Server) Reconfigure the removed drive name for the recovery target disk on the backup server side by executing the MOUNTVOL command.
  • Page 76 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option...

  • Page 77: Disk Backup

    The procedure for disk backup operation is described below. Procedure 1. Prepare three groups of two-replication operation files For details about how to describe the replication operation file, refer to the “NEC Storage Manager Data Replication Command Reference”. disklist0.txt...
  • Page 78 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option #Type:MV Type:RV 0: mvsnap 0:rvsnap3...

  • Page 79: Backup

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option The procedure for performing snapshot backup is described below. The backup target data file and log file have already been paired and are running business operations. In this example, the data file and the log file are created in different volumes with a database name of “snap”.
  • Page 80 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1. Execute the replication (Business Server) Execute replication for the current volume. iSMrc_replicate -file disklist0.txt -wait iSMrc_replicate -file snaplist0.txt -wait Replication execution Data file 3 Data file Data file 2...
  • Page 81 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 2. Execute snapshot backup (Business Server) Execute snapshot backup on the current volume. iSMsql_snapshotbkup -db snap -metafile f:\snap.dat -file disklist0.txt -nowait Snapshot Backup Execution Data file Data file Log file...
  • Page 82 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 5. Execute separation on the metafile volume (Business Server) Issue the separation command to the metafile volume. When using a service to monitor the disk state, stop the service after executing separation.
  • Page 83 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option...
  • Page 84 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option When executing backup hereafter, start it from Procedure 1. disklist0.txt and snaplist0.txt are always in the current RV. Backup first time Data1 Connect Data Separate (MV) Data2 Separate Data3 Data1 Backup second time...

  • Page 85: Recovery

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option If an error occurs on the data file disk but not on the log file disk, a transaction log backup can be made with Microsoft SQL Server 2000. In this case, recovery up to immediately before the error is now possible by applying the transaction log after executing snapshot restoration.
  • Page 86 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Figure 6-21 Performing Recovery from Disk Backup...
  • Page 87 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1 Create the transaction log backup (Business Server) Create a transaction log backup if an error occurs on Microsoft SQL Server 2000’s data disk. T-SQL : BACKUP LOG snap TO DISK = 'g:\sql\backups\trbl.dat' WITH NO_TRUNCATE Procedure 2.
  • Page 88 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 6. Execute snapshot restoration (Business Server) Execute snapshot restoration from the latest backup RV to the MV. When using a service monitor the disk state, start the service after executing the snapshot restoration.
  • Page 89 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option NORECOVERY Apply all the transaction logs. Restore the database. T-SQL : RESTORE DATABASE snap WITH RECOVERY Procedure 8. Start ordinary business operations (Business Server) Start ordinary business operations after making sure that Microsoft SQL Server 2000 operates normally.

  • Page 90: Parallel Operation On Another Node

    Describes operations to starting Microsoft SQL Server 2000 on the search server and using the snapshot backup as the database of another node without stopping search work by the NEC Storage ReplicationControl SQL Option. The standby database is used only for searches. Periodically applying the transaction log offers the advantage of reflecting the latest data without stopping search work.
  • Page 91 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1. Preparation Set Microsoft SQL Server 2000 so that the search server can be used as a standby server. For details, refer to Microsoft SQL Server 2000 Books Online. Procedure 2. Detaching database (Search Server)
  • Page 92 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 6. Issue the replication command (Business Server) Issue the replication command. MVs and RVs are synchronized. iSMrc_replicate -mv d: -mvflg drv iSMrc_replicate -mv e: -mvflg drv Replication Execution Data file...

  • Page 93: Log Distribution

    Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Figure 6-26 Performing Snapshot Backup Procedure 8. Reconfigure the drive name for the search target disk (Search Server) Reconfigure the removed drive name for the search target disk on the search server side by executing the MOUNTVOL command.
  • Page 94 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option By making RVs of the master database, the database can be separated and used by other servers. RVs are used to build test environments, etc. Business Server Replication Server Used as a replication database...
  • Page 95 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 1. Detach the database (Replication Server) Detach the relevant database if the database is run on all the replication servers. T-SQL : EXEC sp_detach_db snap Procedure 2. Remove the drive name for the replication target disk (Replication Server) Remove the drive name for the replication target disk on the replication server side by executing the MOUNTVOL command to prevent new access.
  • Page 96 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Figure 6-28 Performing Replication...
  • Page 97 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option Procedure 6. Issue the snapshot backup command (Business Server) Issue the snapshot backup command. When using a service to monitor the disk state, stop the service before backing up the snapshot. Start the service after executing the snapshot backup.
  • Page 98 Chapter 6 Operations of NEC Storage ReplicationControl SQL Option data for the business server can be used by the replication server...

  • Page 99: Chapter 7 Measures For Errors

    In the operation trace, the messages output to the standard output, to the standard error output and to the event log are recorded together with detailed internal information. Operation trace is output to the same file as that of NEC Storage ReplicationControl. The data is output to iSMrpl.log file in etc\trace folder, within installation folder of NEC Storage ReplicationControl.

  • Page 100: Errors Related To Metafile Configurations

    NEC Storage ReplicationControl SQL Option. When executing the NEC Storage ReplicationControl SQL Option from NetBackup, check the setup of the user name and the password that execute the NEC Storage ReplicationControl SQL Option of NetBackup. The database file on the RV created with the snapshot backup needs to be restored by using the metafile created at that time.

  • Page 101: Appendix A Notes

    Appendix A Notes Appendix A Notes Some precautions about the SQL Server Option are summarized below. For the notes applicable for all data replications, refer to “Installation and Operation (Windows)” in the “Data Replication User’s Manual”. Prior to the installation of the ReplicationControl SQL Option, the ReplicationControl Ver2.1 or later must be installed.
  • Page 102 (13) The NEC Storage ReplicationControl SQL Option is able to process up to 500 databases at a time. However, the number of databases that can actually be processed depends on the unused space in the system resources,...

  • Page 103: Index

    NEC Storage Manager ..........3, 9 NEC Storage PerformanceMonitor......... 3 NEC Storage RemoteDataReplication ....2, 4, 9 NEC Storage ReplicationControl..2, 5, 9, 16, 19, 42 commands ..............22 NEC Storage ReplicationControl SQL Option 2, 7, 9, 10, constructing an evaluation environment ......6 19, 41, 42 data file ................14...
  • Page 104 uninstallation ..............42 worker thread ..............44 update................42...

Table of Contents