SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ(ÈÕÖ¾)
----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹ÔʱʹÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅÏ¢À´»Ö¸´Êý¾Ý¿â¡£
£¨3£©ÄÜ»¹ÔÈ«²¿Êý¾Ý£¬²¢¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÖ¸¶¨µÄʱ¿Ì¡£
£¨4£©Îª±£Ö¤ÊµÏÖ¼´Ê±µã»Ö¸´£¬¶ÔÊý¾Ý¿âµÄËùÓÐ*×÷¶¼½«ÍêÕûµØ¼ÇÈëÈÕÖ¾£¬ÕâÑù£¬ÈÕÖ¾Õ¼Óÿռä½Ï´ó£¬¶ÔÐÔÄÜÒ²ÓÐËùÓ°Ïì¡£
------------------
£¨2£©´óÈÝÁ¿ÈÕÖ¾¼Ç¼»Ö¸´Ä£ÐÍ
------------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹ÔʱʹÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅÏ¢À´»Ö¸´Êý¾Ý¿â¡£
£¨3£©ÈÕÖ¾Öв»¼Ç¼*×÷ϸ½Ú£¨Èçselect into¡¢create indexµÈ£©£¬¶øÖ»¼Ç¼*×÷µÄ×îÖÕ½á¹û£¬Òò´ËÕ¼ÓÃÈÕÖ¾¿Õ¼äС¡£
£¨4£©Ö»Ö§³Ö½«Êý¾Ý¿â»¹Ôµ½ÊÂÎñÈÕÖ¾±¸·ÝµÄʱ¿Ì£¬¶ø²»Ö§³Ö¼´Ê±µã»Ö¸´£¬Òò´Ë¿ÉÄܲúÉúÊý¾Ý¶ªÊ§¡£
-------------------
£¨3£©¼òµ¥»Ö¸´Ä£ÐÍ
-------------------
£¨1£©±¸·Ýʱֻ±¸·ÝÊý¾ÝÎļþ£¬»¹ÔʱҲÓñ¸·ÝµÄÊý¾ÝÎļþ»Ö¸´Êý¾Ý¿â¡£
£¨2£©Ö»Äܽ«Êý¾Ý»Ö¸´µ½Êý¾ÝÎļþ±¸·ÝµÄʱ¿Ì£¬¿ÉÄܲúÉú×î¶àµÄÊý¾Ý¶ªÊ§¡£
£¨3£©²»ÊÊÓÚÉú²úϵͳºÍ´ó¹æÄ£*×÷»·¾³ÏÂÑ¡Óá£
-----------------------------------------
alter database d1 set recovery simple--ÉèÖÃÊý¾Ý¿â»Ö¸´Ä£ÐÍ
alter database d1 set recovery bulk_logged
alter database d1 set recovery full
----------------------------------------------------------------------
ÔÚSQL ServerÖУ¬³ýÁËϵͳÊý¾Ý¿âÍ⣬Äã´´½¨µÄÿһ¸öÊý¾Ý¿â¶¼ÓÐÈýÖֿɹ©Ñ¡ÔñµÄ»Ö¸´Ä£ÐÍ: Simple(¼òµ¥), full(ÍêÕû), bulk-logged(ÅúÁ¿ÈÕÖ¾)¡£ ÏÂÃæÕâÌõÓï¾ä¿ÉÒÔÏÔʾ³öËùÓÐÔÚÏßÊý¾Ý¿âµÄ»Ö¸´Ä£ÐÍ:
SELECT name, (SELECT DATABASEPROPERTYEX(name, 'RECOVERY')) RecoveryModel from master..sysdatabases ORDER BY name
SQL Server 2005¼°ÒÔÉϰ汾Ҳ¿ÉÒÔʹÓÃÏÂÃæÕâÌõÓï¾äÀ´²é¿´:
SELECT name, recovery_model_desc from master.sys.databases ORDER BY name
Èç¹ûÏë¸Ä±äÊý¾Ý¿âµÄ»Ö¸´Ä£ÐÍ£¬¿ÉÒÔʹÓÃÏÂÃæSQLÓï¾ä:
¼òµ¥»Ö¸´Ä£ÐÍ:ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE
ÍêÕû»Ö¸´Ä£ÐÍ:ALTER DATABASE AdventureWorks SET RECOVERY FULL
ÅúÁ¿ÈÕÖ¾»Ö¸´Ä£ÐÍ:ALTER DA
Ïà¹ØÎĵµ£º
Ò»¸ö¼òµ¥µÄÀý×Ó£º
ÏȽ¨Ò»¸öC#Àࣺ
ÒýÓÃSystem.Data.Linq.dll³ÌÐò¼¯£¬
using System.Data.Linq.MappingºÍ
using System.Data.Linq Á½¸ö¿Õ¼ä¡£
[Table]
public class Inventory
{
[Column]
public string Make;
[Column]
public string Color;
&nbs ......
SQL×¢Èë¹¥»÷
¡¡¡¡SQL×¢Èë¹¥»÷ÊǺڿͶÔÊý¾Ý¿â½øÐй¥»÷µÄ³£ÓÃÊÖ¶ÎÖ®Ò»¡£Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´ú ......
1 ±ÜÃâÎ޼ƻ®µÄÈ«±íɨÃè
ÈçÏÂÇé¿ö½øÐÐÈ«±íɨÃ裺
- ¸Ã±íÎÞË÷Òý
- ¶Ô·µ»ØµÄÐÐÎÞÈ˺ÍÏÞÖÆÌõ¼þ£¨ÎÞWhere×Ӿ䣩
- ¶ÔÓÚË÷ÒýÖ÷ÁУ¨Ë÷ÒýµÄµÚÒ» ......
sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«
·þÎñÆ÷½ÇÉ«
ËùÓеķþÎñÆ÷½ÇÉ«¶¼ÊÇ“¹Ì¶¨µÄ”½ÇÉ«£¬²¢ÇÒ£¬´ÓÒ»¿ªÊ¼¾Í´æÔÚÓÚÄÇÀï——×Ô°²×°ÍêSQL ServerµÄÄÇÒ»¿ÌÆð£¬Ä㽫ӵÓеÄËùÓзþÎñÆ÷½ÇÉ«¾ÍÒѾ´æÔÚÁË¡£
½Ç¡¡¡¡É«
ÌØ¡¡¡¡ÐÔ
sysadmin
¸Ã½ÇÉ«Äܹ»Ö´ÐÐSQL ServerÉϵÄÈκβÙ× ......