SQL SERVER 2005Êý¾Ý¿â¾µÏñ
ͨ¹ýµÚÆßÆں͵ڰËÆÚµÄÎÄÕ£¬ÎÒÃÇÁ˽âÁËSQL SERVER 2005Êý¾Ý¿âµÄÔÀí¡¢ÊµÏÖ·½Ê½ÒÔ¼°SQL SERVER 2005Ôڸ߿ÉÓᢸßÐÔÄܺ͸߱£»¤Ä£Ê½Ï»áÓв»Í¬µÄÊý¾Ý¿â¾µÏñ״̬£¬¶øÇÒÁ˽âÁËSQL SERVER 2005ÔÚ²»Í¬Ó¦ÓÃģʽϹÊÕÏתÒƵķ½Ê½¡£½ÓÏÂÀ´£¬ÎÒÃǽ«¸ù¾ÝÒÔÏÂÁ½Ààʼþ¶ÔÊý¾Ý¿â¾µÏñÔ¤ÆڵĿÉÓÃÐÔ½øÐзÖÎö£º
Ò»¸ö»ò¶à¸ö·þÎñÆ÷»òÕßÊý¾Ý¿âʧ°Ü
·þÎñÆ÷Ö®¼äÒ»Ìõ»ò¶àÌõͨÐÅÁ´Â·Ê§°Ü
Ò»°ãÀ´½²£¬·þÎñÆ÷ʧ°Ü¿ÉÄÜÊÇÓÉÓÚij¸ö¾µÏñ»ï°éÊý¾Ý¿â»òÕßij¸öSQL SERVER 2005ʵÀý²»¿ÉÓᣴËÍ⣬¼´Ê¹·þÎñÆ÷±¾Éí¿ÉÒÔ¼ÌÐøÔËת£¬µ«ÊÇÊý¾Ý¿â¾µÏñ»ï°é·þÎñÆ÷Ö®¼äµÄͨÐÅÁ´Â·¿ÉÄÜÖжϡ£ÒÔϳ¡¾°ÖУ¬Á½¸ö×é¼þµÄͬʱʧ°Ü±»ÊÓΪһ¸ö×é¼þ½ô½Ó×ÅÁíÒ»¸ö×é¼þµÄ˳Ðòʧ°Ü¡£ÀýÈ磬SERVER AºÍB³öÏÖÁËͬʱʧ°Ü£¬¾µÏñϵͳ½«¸ÃʼþÊÓΪһ¸ö˳Ðòʼþ£¬Ë³ÐòΪServer Aʧ°ÜÈ»ºóServer Bʧ°Ü£¬»òÕß·´¹ýÀ´¡£
ʹÓÃÏÂÃæµÄ¹æÔòÀ´Åж¨Ò»¸ö²»¿ÉÓÃʼþµÄÔ¤ÆÚ½á¹û£º
1¡¢ µ±safetyÉèÖÃΪFULLʱ£¬Ö÷·þÎñÆ÷ÐèÒªÖÁÉÙһ̨ÆäËü·þÎñÆ÷²ÅÄÜÐγÉquorumÀ´±£³ÖÊý¾Ý¿â¿ÉÓá£Èç¹ûÖ÷·þÎñÆ÷ÎÞ·¨×é³Équorum£¬ÕâʱÖ÷·þÎñÆ÷Ò²¾ÍÎÞ·¨ÌṩÊý¾Ý¿â·þÎñÁË¡£
2¡¢ µ±safetyÉèÖÃΪFULL£¬Èç¹û¾µÏñ·þÎñÆ÷ºÍ¼ûÖ¤·þÎñÆ÷¶¼ÎÞ·¨ÁªÏµµ½Ö÷·þÎñÆ÷£¬ÄÇô¾µÏñ·þÎñÆ÷¿ÉÒԺͼûÖ¤·þÎñÆ÷×é³Équorum£¬²¢ÇҸıäÆä½ÇÉ«£¬Ê¹Ö®³ÉΪеÄÖ÷·þÎñÆ÷£¬Õâ¾ÍÊÇ×Ô¶¯µÄ¹ÊÕÏתÒÆ¡£
3¡¢ µ±safetyÉèÖÃΪFULL£¬Èç¹ûÖ÷·þÎñÆ÷ºÍ¼ûÖ¤·þÎñÆ÷ºÏ×÷×é³Équorum£¬µ«ÊǶϿªÁ˺;µÏñ·þÎñÆ÷Á¬½Ó£¬ÄÇôÖ÷·þÎñÆ÷ʧ°Ü½«²»ÔÊÐí¾µÏñ·þÎñÆ÷ºÍ¼ûÖ¤·þÎñÆ÷×é³Équorum£¬Ò²²»ÔÊÐí¾µÏñ·þÎñÆ÷³Ðµ£Ö÷·þÎñÆ÷µÄ½ÇÉ«£¬ÕâÑù¿ÉÒÔ·ÀÖ¹Ëù×öµÄ¹¤×÷ÓÉÓڻỰÖж϶ø¶ªÊ§¡£
4¡¢ µ±safetyÉèÖÃΪFULL£¬Èç¹ûʧ°ÜµÄÖ÷·þÎñÆ÷ÔÚÍ£»ú»òÕß¹ÂÁ¢ºóÖØмÓÈë»á»°£¬Í¬Ê±¾ÉµÄ·þÎñÆ÷ÒѾ³Ðµ£ÁËÖ÷·þÎñÆ÷µÄ½ÇÉ«£¨ºÍ¼ûÖ¤·þÎñÆ÷×é³Équorum£©£¬ÄÇô¾ÉµÄÖ÷·þÎñÆ÷½«Ôڴ˴λỰÖге£Ð¾µÏñ·þÎñÆ÷½ÇÉ«¡£
5¡¢ µ±safetyÉèÖÃΪFULL£¬²¢ÇһỰÖÐûÓмûÖ¤·þÎñÆ÷£¬»òÕß¼ûÖ¤²»ÖªºÎ¹ÊÍ˳öÁ˻Ự£¬¾µÏñ»ï°é·þÎñÆ÷µÄʧ°Ü½«µ¼ÖÂÎÞ·¨×é³Équorum£¬Ö÷·þÎñÆ÷Ò²Òò´Ë²»ÔÙ±£³ÖÖ÷Êý¾Ý¿â¿ÉÒÔʹÓá£
¸ß¿ÉÓó¡¾°ÖзþÎñÆ÷ʧ°Ü
¸ß¿ÉÓòÙ×÷ģʽϵÄÊý¾Ý¿â¾µÏñÆäÄ¿µÄ¾ÍÊǾ¡¿ÉÄÜÔö¼ÓÊý¾Ý¿âµÄ¿ÉÓÃÐÔ£¬ÔÚÕâÖÖģʽÏ£¬Èç¹ûÖ÷Êý¾Ý¿âÎÞ·¨·ÃÎÊ£¬ÄÇôÊý¾Ý¿â¾µÏñ½«Ñ¸ËÙʹ¾µÏñÊý¾Ý¿â¿ÉÒÔ½ÓÊÜ·ÃÎÊ¡£ÔÚÏÂÃæµÄ¸ß¿ÉÓó¡¾°ÖУ¬Server A×÷ΪÖ÷·þÎñÆ÷Æô¶¯£¬Server BÊǾµÏñ·þÎñÆ÷£¬¶øServer WÊǼûÖ¤·þÎñÆ÷£¬ÈçͼËùʾ£º
ËùÓÐÕâÈý̨·þÎñÆ÷¿ÉÒÔÔÚͬһ¸öÕ¾µãʹÓþÖÓòÍø
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Collections;
using System.Data.SqlClient;
namespace DAL
{
/// <summary>
/// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
/// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦Óà ......
1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄÇ°Ê®Ìõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0Ìõ¼Ç¼¿ªÊ¼£¬Íùºó ......
.Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH NO_LOG
2.½Ø¶ÏÊÂÎñÈÕÖ¾£º
BACKUP LOG ¿âÃû WITH NO_LOG
3.ÊÕËõÊý¾Ý¿âÎļþ(Èç¹û²»Ñ¹Ëõ,Êý¾Ý¿âµÄÎļþ²»»á¼õС
ÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãҪѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,Ö±½Ó ......
1. In "MicroSoft SQL Server Management Studio", right click SQL Server instance, select "Properties", select "Security" in left panel and check "SQL Server and Windows Authentication mode" in right Panel.
2. In "SQL Server Configuration Manager", select "SQL Server Network Configuration > ......
1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡¡¡¡6 MS SQLʶ±ð·ûÊÇ[],[type]±íÊ ......