Please enter search query.
Search <book_title>...
Cluster Server 8.0 Implementation Guide for Microsoft SQL Server - Windows
Last Published:
2021-12-21
Product(s):
InfoScale & Storage Foundation (8.0)
Platform: Windows
- Section I. Introducing Veritas InfoScale solutions for application high availability
- Understanding the InfoScale solutions for application high availability
- About the VCS agents for SQL Server
- How VCS monitors storage components
- How application availability is achieved in a physical environment
- How is application availability achieved in a VMware virtual environment
- Managing storage and installing the VCS agents
- Installing SQL Server
- Understanding the InfoScale solutions for application high availability
- Section II. Configuring SQL Server in a physical environment
- Overview
- Configuring the VCS cluster
- Configuring the SQL Server service group
- Configuring a SQL Server service group using the wizard
- Making SQL Server user-defined databases highly available
- Verifying the service group configuration
- Administering a SQL Server service group
- Configuring an MSDTC service group
- Configuring the standalone SQL Server
- Configuring an Active/Active cluster
- Configuring a disaster recovery setup
- Section III. Configuring SQL Server in a VMware environment
- Configuring application monitoring using the Veritas High Availability solution
- Administering application monitoring
- Administering application monitoring using the Veritas High Availability tab
- Administering application availability using Veritas High Availability dashboard
- Understanding the dashboard work area
- Section IV. Appendixes
- Appendix A. Troubleshooting
- Error and warning messages from VCS agent for SQL Server
- Troubleshooting application monitoring configuration issues
- Troubleshooting Veritas High Availability view issues
- Appendix B. Using the virtual MMC viewer
- Appendix A. Troubleshooting
Moving the existing SQL Server data files and user databases
After completing the SQL installation and configuration on the additional nodes, move the existing standalone SQL Server data files and user databases from the local drive to the shared drives to ensure proper failover operations in the cluster. Complete the following tasks to move the databases:
- From the SQL Server Service Manager, stop the SQL Server service.
- Verify that you have backed up your existing data.
- Import the volumes or LUNs to the node where the original files are located on the local drives and mount the volumes (add drive letters).
- Move the SQL Server data files and user databases to the shared volumes or LUNs. Follow the procedures described in Microsoft Knowledge Base Article - 224071: INF: Moving SQL Server databases to a New Location with Detach/Attach.
Refer to: http://support.microsoft.com/default.aspx?scid=kb;en-us;224071.
- Restart SQL Server.
More Information