Sql Server 2000Òì³£±¸·Ý - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÓÐÁ½Ì¨·þÎñÆ÷£¬Ò»Ì¨ÊÇÖ÷·þÎñÆ÷£¬Ò»Ì¨ÊDZ¸Ó÷þÎñÆ÷¡£
²»ÖªµÀ´Óʲôʱºò¿ªÊ¼£¬ÕâÁ½Ì¨·þÎñÆ÷£¬Ò»·ÖÖÓ±¸·ÝÒ»´ÎSQLµÄÊý¾Ý¿â£¬±¸·ÝÃû³ÆÈ磺¡°yyyyMMddHHmmss.bak¡±,ûÓж೤ʱ¼ä£¬´ÅÅ̾ÍÂúÁË¡£
´Ó¡°·þÎñ¹ÜÀíÆ÷¡±°ÑSql Server·þÎñ¹Ø±ÕÁË£¬¾Í»áÍ£Ö¹±¸·ÝÁË¡£·þÎñ¿ªÆôºó£¬Ò»»áÓÖ×Ô¶¯±¸·ÝÁË¡£²¢ÇÒÔÚ"ÆóÒµ¹ÜÀíÆ÷"µÄά»¤¼Æ»®ºÍ×÷ÒµÀﲢûÓÐÉèÖö¨Ê±±¸·Ý¡£
°ÑSql ServerÐ¶ÔØºó£¬ÔÙ°²×°ºó£¬Ò»»áÓÖ×Ô¶¯±¸·ÝÁË¡£ÎÒ¶¼Ææ¹ÖÁË¡£
Ó¦ÓóÌÐòʼþÏÔʾÈçÏÂÐÅÏ¢£º
ʼþÀàÐÍ: ÐÅÏ¢
ʼþÀ´Ô´: MSSQLSERVER
ʼþÖÖÀà: (6)
ʼþ ID: 17055
ÈÕÆÚ: 2010-5-5
ʼþ: 11:10:22
Óû§: N/A
¼ÆËã»ú: ZJ
ÃèÊö:
18264:
Êý¾Ý¿âÒѱ¸·Ý: Êý¾Ý¿â: ScalePubFlat£¬´´½¨ÈÕÆÚ£¨Ê±¼ä£©: 2010/05/05(10:27:37)£¬×ª´¢µÄÒ³Êý: 32834£¬µÚÒ»¸ö LSN: 17533:25:1£¬×îºóÒ»¸ö LSN: 17533:27:1£¬×ª´¢É豸µÄÊýÄ¿: 1£¬É豸ÐÅÏ¢: (FILE=1, TYPE=DISK: {'d:\ScaleBackup\20100505110953.bak'})¡£
Óйظü¶àÐÅÏ¢£¬Çë²ÎÔÄÔÚ http://go.microsoft.com/fwlink/events.asp µÄ°ïÖúºÍÖ§³ÖÖÐÐÄ¡£
Êý¾Ý:
0000: 58 47 00 00 0a 00 00 00 XG......
0008: 03 00 00 00 5a 00 4a 00 ....Z.J.
0010: 00 00 0d 00 00 00 53 00 ......S.
0018: 63 00 61 00 6c 00 65 00 c.a.l.e.
0020: 50 00 75 00 62 00 46 00 P.u.b.F.
0028: 6c 00 61 00 74 00 00 00 l.a.t...
ÈçºÎ½â¾ö£¬Çë´ó¼Ò¸øÕï¶Ïһϡ£
¡°±¸·Ýµ½¡°µÄ±¸·ÝÎļþÃû³ÆÒ²Ëæ×Åʱ¼ä±ä»¯¡£
¿´¿´ÊDz»ÊÇÓÐWindowsÅų̼ƻ®ÔÚ×ö±¸·Ý¡£
¿´¿´¼Æ»®ÈÎÎñÊDz»ÊÇÄãдÁËÅú´¦Àí ¶¨Ê±±¸·Ý ¿´ÏµÍ³¼Æ»®ÈÎÎñ ÓеĻ°È¡ÏûÄÇÄǸöÈÎÎñ »òÕ
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......