Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

java½«excelµ¥Ôª¸ñÊý¾Ýת»»³ÉsqlÓï¾ä

Ê×ÏÈÒªÓÐ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ÈçºÎÌá¸ßÊý¾Ý¿â»¹Ô­µÄËÙ¶È

Ó°ÏìÊý¾Ý¿â»¹Ô­ËٶȵÄÒòËØºÍÓ°ÏìÊý¾Ý¿â±¸·ÝËٶȵÄÒòËØÏàͬ¡£³ý´ËÖ®Í⣬¼ÙÈçÄãʹÓÃSQL Server 2005µÄ»°£¬Ä㻹¿ÉÒÔÆô¶¯ÁíÍâÒ»¸öÓÅ»¯ÈÎÎñÀ´»¹Ô­µ±Ç°²»´æÔÚµÄÊý¾Ý¿â£¬ÔËÐл·¾³ÎªWindows XP£¬Windows 2003 Server »ò¸üа汾¡£
Perform Volume Maintenance Tasks
µ±Ä㻹ԭһ¸öеÄÍêÕûÊý¾Ý¿âÊÇ£¬SQL Server¶Á±¸·ÝÎļþÍ·£¬È»ºó´ ......

sql xml ÈëÃÅ

*
sql xml ÈëÃÅ:
    --by jinjazz
    --http://blog.csdn.net/jinjazz
   
    1¡¢xml:        ÄÜÈÏÊ¶ÔªËØ¡¢ÊôÐÔºÍÖµ
   
    2¡¢xpath:    ѰַÓïÑÔ£¬ÀàËÆwind ......

¶¯Ì¬SQL(Dynamic SQL)

----start
    ¶¯Ì¬SQLÊÇÔÚ³ÌÐòÔËÐÐʱ¹¹ÔìµÄ£¬ÒªÖ´Ðе¥ÌõSQL£¬Ê¹ÓÃEXECUTE IMMEDATE Óï¾ä£»µ±ÅúÁ¿Ö´ÐÐSQLʱ£¬ÏÈʹÓÃPREPARE Óï¾ä¹¹ÔìSQL£¬È»ºóʹÓÃEXECUTE Óï¾äÖ´ÐС£
Ò»£ºPrepareÓï¾ä£ºÓÃÀ´¹¹ÔìÅúÁ¿SQL
Óï·¨£º
PREPARE <sql-statement> [OUTPUT] INTO <result> [INPUT INTO] <input> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ