SQL Mirror HA(SQL serverµÄ¸ß¿ÉÓÃÐÔ)[×ªÔØ]
¶ÔSQL Server 2008 ½øÐÐMirrorµÄ»ù±¾ÅäÖü°°²×°¡£
×¼±¸¹¤×÷
1. Principal ÓëMirror ÒÔ¼° Witness Èý̨ʵÀý¶¼°²×°ÎªÏàͬ°æ±¾£¬Ä¿Ç°Êǵ½SQL Server 2008 SP1¡£
2. ÐèÒªÓÐÒ»¸öÓòÕÊ»§·Ö±ðÌí¼Óµ½ Èý̨Êý¾Ý¿âʵÀýËùÔÚµÄServer µÄ Administrators×é¡¢ÒÔ¼°SQL Server Ïà¹ØµÄ×éÖУ» ÓÉÓÚ¾ßÌåµÄ×éµÄ¹¦Äܲ»Çå³þ£¬Òò´Ë½¨ÒéËùÓÐ×é¶¼Ìí¼Ó¸ÃÓòÕÊ»§£¬È·±£È¨ÏÞÔËÐÐÕý³£¡£
3. ½«µÚ¶þ²½ÖеÄÓòÕÊ»§ÉèÖÃΪSQL Server ·þÎñ£¬SQL Server Agent µÄÆô¶¯ÕÊ»§£¬²¢ÖØÆô·þÎñ¡£
4. È·±£Principal ÓëMiroor Á½Ì¨ÊµÀýÉϵÄÊý¾ÝÊý¾Ý¼°ÈÕÖ¾Ïàͬ¡£±¸·ÝģʽΪÍêÈ«±¸·Ý£¬»Ö¸´Ä£Ê½ÎªÍêÈ«£¬ÏòMirrorʵÀýÉϻָ´Êý¾Ý¿âʱ±ØÐëÑ¡ÔñΪNoRecoveryģʽ¡£
´´½¨EndPoint
1. ÔÚPrincipalÓë MirrorʵÀýÉÏ´´½¨EndPoint£¬ÔËÐнű¾£º
Create EndPoint On Principal and Mirror Instance
CREATE ENDPOINT mirroring_ep
STATE=STARTED
AS TCP (LISTENER_PORT=5022)
FOR DATABASE_MIRRORING
(ROLE = PARTNER, ENCRYPTION = SUPPORTED)
--»ò
CREATE ENDPOINT mirroring_ep
STATE=STARTED
AS TCP (LISTENER_PORT=5022)
FOR DATABASE_MIRRORING
(AUTHENTICATION=WINDOWS NTLM,ROLE = PARTNER)
2. ÔÚWitnessʵÀýÉÏ´´½¨EndPoint£¬ÔËÐнű¾£º
Create EndPoint On Witness Instance
CREATE ENDPOINT mirroring_ep
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING
( ENCRYPTION = SUPPORTED, ROLE=WITNESS );
--»ò
CREATE ENDPOINT mirroring_ep
STATE=STARTED
AS TCP (LISTENER_PORT=5022)
FOR DATABASE_MIRRORING
(AUTHENTICATION=WINDOWS NTLM,ROLE = WITNESS)
²é¿´EndPoint¼°É¾³ýEndPoint½Å±¾£º
Select * from Sys.database_mirroring_endpoints
Select * from sys.database_mirroring
Drop Endpoint endpoint_mirroring
´´½¨ Mirror Session
1.ÔÚMirror ʵÀýÉÏ´´½¨Session£¬ÔËÐнű¾£º
ALTER DATABASE DataBaseName
SET PARTNER = 'TCP://PrincipalServerName:5022';
2.ÔÚPrincipal ʵÀýÉÏ´´½¨Session £¬ÔËÐнű¾£º
ALTER DATABASE DataBaseName
SET PARTNER = 'TCP://MirrorServerName:5022';
3.ÔÚPrincipal ʵÀýÉÏÖ¸¶¨Witness£¬ÔËÐнű¾£º
ALTER DATABASE HB2008_Gome
SET
Ïà¹ØÎĵµ£º
Ê×ÏÈÒªÓÐjxlÀà¿â¡£
³ÌÐòÈçÏ£º
import java.io.*;
import jxl.*;
public class ExcelToSql {
public static void main(String args[])
{
try
{
Workbook book= Workbook.getWorkbook(new File("D:\\workspaceuse6\\foundation\\test\\com\\gres ......
Ó°ÏìÊý¾Ý¿â»¹ÔËٶȵÄÒòËØºÍÓ°ÏìÊý¾Ý¿â±¸·ÝËٶȵÄÒòËØÏàͬ¡£³ý´ËÖ®Í⣬¼ÙÈçÄãʹÓÃSQL Server 2005µÄ»°£¬Ä㻹¿ÉÒÔÆô¶¯ÁíÍâÒ»¸öÓÅ»¯ÈÎÎñÀ´»¹Ôµ±Ç°²»´æÔÚµÄÊý¾Ý¿â£¬ÔËÐл·¾³ÎªWindows XP£¬Windows 2003 Server »ò¸üа汾¡£
Perform Volume Maintenance Tasks
µ±Ä㻹ÔÒ»¸öеÄÍêÕûÊý¾Ý¿âÊÇ£¬SQL Server¶Á±¸·ÝÎļþÍ·£¬È»ºó´ ......
*
sql xml ÈëÃÅ:
--by jinjazz
--http://blog.csdn.net/jinjazz
1¡¢xml: ÄÜÈÏÊ¶ÔªËØ¡¢ÊôÐÔºÍÖµ
2¡¢xpath: ѰַÓïÑÔ£¬ÀàËÆwind ......
----start
¶¯Ì¬SQLÊÇÔÚ³ÌÐòÔËÐÐʱ¹¹ÔìµÄ£¬ÒªÖ´Ðе¥ÌõSQL£¬Ê¹ÓÃEXECUTE IMMEDATE Óï¾ä£»µ±ÅúÁ¿Ö´ÐÐSQLʱ£¬ÏÈʹÓÃPREPARE Óï¾ä¹¹ÔìSQL£¬È»ºóʹÓÃEXECUTE Óï¾äÖ´ÐС£
Ò»£ºPrepareÓï¾ä£ºÓÃÀ´¹¹ÔìÅúÁ¿SQL
Óï·¨£º
PREPARE <sql-statement> [OUTPUT] INTO <result> [INPUT INTO] <input> ......