tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P71

Microsoft SQL Server 2008 R2 Unleashed- P71:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 644 CHAPTER 20 Database Mirroring The ALTER DATABASE and DROP ENDPOINT SQL commands break mirroring on the principal and remove the endpoint ALTER DATABASE AdventureWorks set partner off go DROP ENDPOINT EndPoint4DBMirroring1430 go From the mirror server instance not the principal you run the DROP DATABASE and DROP ENDPOINT SQL commands as follows DROP DATABASE AdventureWorks go DROP ENDPOINT EndPoint4DBMirroring1440 go From the witness server instance you remove the endpoint as follows DROP ENDPOINT EndPoint4DBMirroring1450 go To verify that you have removed these endpoints from each server instance you simply run the following SELECT statements select name type_desc port ip_address from select name role_desc state_desc from All references to the endpoints and roles are removed. You can also take a peek at the SQL Server log entries being made as you remove database mirroring 02 05 2009 13 06 42 spid55 Unknown The Database Mirroring protocol transport is disabled or not configured. 02 05 2009 13 06 40 spid55 Unknown The Database Mirroring protocol transport has stopped listening for connections. 02 05 2009 12 52 55 spid19s Unknown Database mirroring connection error 4 An error occurred while receiving data 64 The specified network name is no longer available. for TCP REM1233. 1440 . 02 05 2009 12 52 55 spid19s Unknown Error 1474 c Severity 16 c State 1. 02 05 2009 12 52 55 spid19s Unknown Database mirroring connection error 4 An error occurred while receiving data 64 The specified network name is no longer available. for TCP REM1233. 1450 . 02 05 2009 12 52 55 spid19s Unknown Error 1474 Download from Testing Failover from the Principal to the Mirror 645 c Severity 16 c State 1. 02 05 2009 12 51 14 spid21s Unknown Database mirroring has been terminated for database AdventureWorks . These are all informational messages only. No user action is required. As you can see from these messages you