Hướng dẫn học Microsoft SQL Server 2008 part 121

Một cách khác để tìm thông tin này là để mở SQL Server Errorlog và tìm kiếm dòng ˝ tên NETBIOS của nút địa phương có nghĩa là chạy các máy chủ là ˝. Thông tin này trở nên đặc biệt quan trọng trong quá trình phân tích sau khi chết. | Part VI Enterprise Data Management Another way to find this information is to open the SQL Server Errorlog and search for the line The NETBIOS name of the local node that is running the server is . This information becomes especially important during postmortem analysis. Sometimes the DBA may not even know if the SQL Server 2008 instance she is administering is a clustered instance or a stand-alone instance. To find out if the current SQL Server instance is clustered execute the following command SELECT SERVERPROPERTY IsClustered If this is a SQL Server 2008 failover clustering instance then it will return a value of 1 otherwise it will return a value of 0. To view the cluster nodes on which the SQL Server 2008 failover clustering instance can run use the dynamic management view DMV as shown SELECT FROM To view the shared disks that the SQL Server 2008 failover clustering instance can access use the DMV as shown SELECT FROM A SQL Server 2008 failover clustering instance can only use shared drives for its databases. It cannot use local drives not even for the tempdb database that is created every time SQL Server is started. The DMV will display all the shared drives SQL Server 2008 can access. These are the drives that were selected during the installation. To add a new shared drive perform the following steps 1. Open the Cluster Administrator tool in Windows 2003 Failover Cluster or the Failover Cluster Management tool in Windows 2008 Failover Cluster. 2. Move the shared disk to the SQL Server 2008 group. 3. Right-click the SQL Server resource and select Take Offline. This will disconnect the clients so it should be planned in advance. 4. Right-click the SQL Server resource and select Properties. Click the Dependencies tab and select Modify. Add the new shared drive as a dependency to SQL Server. 5. Bring the SQL Server .